Help - update one sheet from 11 other sheets automatically

M

marsh

Hello. I am unsure how to do something that has been assigned to m
where I work.

I have a spreadsheet with 11 worksheets in it - All have the sam
column headings and go from columns A thru P and of course hav
different information in all of them. The rows vary on each as thes
worksheets are updated daily with new lines of information. Basicall
I need an additional worksheet in this workbook that will automaticall
update every time any of the other worksheets are updated with ne
information/new lines. Any help or examples would be greatl
appreciated :
 
D

David McRitchie

Hi Marsh..,,
Not knowing how your sheets work with each other, I would expect
that you would want to use VLOOKUP Worksheet Function.
http://www.mvps.org/dmcritchie/excel/vlookup.htm

If the data in each sheet is in exactly the same position from one
sheet to another with row numbers match the same description
on each sheet then the following may be of interest.
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
which is designed more for ease of setting up rather than something
that looks like a terrific report -- but you could hide rows that
you don't want to see.
 
Top