In the new worksheet and once the data is in there is there any way to leave
the data behind and severe any reference to =sheet2!A1 on the master sheet.



"KC8DCN" wrote:

Hi.

I have just one workbook with multiple spreadsheets. I have 1 master
spreadhseet that I want to be updated by the other spreadsheets automatically
every time I add something new to the other spreadsheets. I'm not sure of
the best possible way to do this.

Ex. If I had five item numbers to one spreadsheet and 3 items numbers to
another spreadsheet, I would like the master list to be automatically updated
in no certain order with those 8 numbers and other information.

Any ideas? Thanks!