Linked spreadsheets

[guest1970]

I have a number of spreadsheets saved in a folder which link to one master data sheet. When i copy the folder over for the next accounting period, the link on the spreadsheets is still looking the data sheet from the previous month. How can i overcome this so that the links look at the correct data sheet?

[#2]

a quick info about Links
Description of link management and storage in Excel
https://support.microsoft.com/en-gb/help/328440/description-of-link-management-and-storage-in-excel

Thank you for letting me help
Nikolino
I know that I don't know (Socrates)

[#3]

Hi @guest1970 

You need to make one cell using that as parameter & then use the indirect function to map it to the new sheet, note that if you have lot of formula then INDIRECT Function may reduce the calculation speed. 

Below is the link which might be helpful for you, where you can link the data from multiple sheet into Excel Master Sheet by making it dynamic. You can use the same logic for your report

https://youtu.be/ROym3e-S4OQ

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more