I have a master spreadsheet (Tab 1) which goes to cell EM:3500. The boss filters for specific data, copy/pastes the filtered data to another tab and then runs calculations. This easily results in 20 tabs for a specific project. The problem is keeping up with revisions to the master data. How can I link her tabs back to the original data (Tab 1) to Refresh when changes are made or is there another method to create her tabs? I don't think she'll use pivots due to the number of columns involved. Or possibly, keep all of her linked tabs in a separate file from the master data? Have you any suggestions?