Dynamically update the worksheet value

Hi!

I have different worksheets which are link together to automatically update values. These worksheets are in a folder as shown in my code. Now I want to reuse the worksheets, so I copied the worksheets and put them in another folder named "2019-2020". I then proceeded deleting the values of the worksheets except the formulas. I found out that the formulas does not dynamically changed the reference. What should I do so that whenever I want to reuse my worksheets, I will no longer change my formula, it will just dynamically change. Is this possible in excel?

Please Login or Register  to view this content.

I think it can't be done. I then have to redo the formulas all over again.

CTRL-H - find and replace????

It's bound to be do-able by VBA, about which I know nothing.

However, I think you are not fully understanding my suggestion. Find and Replace will take 2 or 3 seconds to set up; and will take 2-3 seconds to change ALL of the formulae in a single sheet.

Five sheets per workbook, 5 workbooks, total: 1 to 1.5 minutes.....