Hi, wondering if anyone can help me. I've created a spreadsheet and the first sheet is my totals sheet, this sheet has formulas that lookup values in sheet2 thru sheet99. I've saved this spreadsheet as my master copy. I need to open new spreadsheets from time to time and copy these sheets from the master copy to the new spreadsheet, but when I do this, my first sheet in the new spreadsheet is looking up those values in the master copy spreadsheet, I don't want that, I want it to lookup the values in the new spreadsheet I've copied to...please help
