ExcelBanter - Consolidated Sheets

Hi Dana,
If I have understood your requirements properly, you have data in many
sheets and you have consolidated them in a new sheet. By your statement "the
consolidated sheet to read from my originals", I understand that it should
update the data in the consolidated sheet when ever the data in the sheet
undergoes change. If this is right and you have used the Data Consolidate
option, tick "Create links to source data". According to "Help", this should
ensure automatic updating of data in the consolidated sheet. But I have not
found this useful. I had used a pivot table instead more successfully. The
pivot table consolidates data and also updates it when ever you press the
"Refresh" button (see ! mark) in the pivot table toolbar which automatically
appears when ever you create a pivot table. If your updating means insertion
of new data say at the end of each worksheet, I suggest that while taking the
ranges to be used for the pivot table in each worksheet, include one extra
row. While inserting new data use the blank row that too after inserting a
new row ( so that one blank row always remains below). The range specified
for the pivot table thereby remains dynamic.

"Dana" wrote:

I've consolidated some spreadsheets, but Im trying to get my consolidated
sheet to "read" from my originals? How can I accomplish this?