[LeeH]

I'll try to explain this as simply as possible. Note that I have good basic Excel skills, but far from advanced Excel skills.

Spreadsheet "Report" is in "A" directory. It pulls data from another spreadsheet "Jan. P&L" that is also in directory "A", and several others.

Next month I'll need to duplicate this, but in directory "B". If I just copy Spreadsheet "Report" to directory "B" the links still point to directory "A", right? So if I create a new spreadsheet "Feb P&L" and put it in directory "B", my new spreadsheet "Report" won't see the new data unless I redirect all the links, of which there will be many.

Is there a way to have the main "Report" spreadsheet act as a template where it will look locally for spreadsheet "[current month]P&L" without having to manually change the links? I'd like to be able to automate as much of this as possible.