Hi, I have a spreadsheet which is getting large and unweildy. Because a lot
of the standard data is stored in a Data worksheet, I copied it out to
another spreadsheet.

My problem is that for my master sheet to be able to find the data on the
Data sheet, the data sheet needs to be open as well. Is there anye asy way
of either making my master sheet retrieve the data from the data sheet when
it ISN'T open OR to automatically open the data sheet when I open the master
sheet?

Thanks

Mike