I understand that and have actually done it in the past many times. But
this particular one is a bit different. I'll explain it a little
further. The end "consolidated" sheet will contain the information
necessary for a mail merge, first last names address, etc. The other 10
worksheets are peoples information, stored in the same format, that is
being changed and updated with new rows added daily. What I'm saying is
that any one of those 10 wooksheets could be changed or modified at any
time, how do I keep the consolidated one up-to-date, to reflect these
new rows added and changes on any one of the sheets? By using the
formula "=Sheet1!B4" i would only be able to update from one sheet, i
need to be able to update from 10 different sheets.