Save 2 workbooks as current month and use as template for future months

Hello,

How do you set up a workbook for a month with formulas linked to other workbook with same month name.
Example:
1) Workbook 1 April Data
2) Workbook 2 April Summary
3) Workbook 2 April Summary is linked to Workbook 1 April Data to pull data using Vlookup and IF statements.

If I save above workbooks as April then in May want to use April format and save as May, my formulas are still referring to April Workbook 1 Data. How can I save or copy the two files and formulas change to appropriate month as saved file (new)? Is this possible?

Thank you very much.

Hi,
One method is find and replace the source workbook name, just a click you can change all workbook links

Eg. if you have this formula in May Summary ='[April Data.xlsx]Sheet1'!$A$2 , which you want to change into ='[May Data.xlsx]Sheet1'!$A$2
then Find and Replace (Ctrl H) Find > April Data.xlsx Replace With May Data.xlsx and Replace All.
This will change all the workbook link to the new file

2nd Method
Change All the formula enclosed in =INDIRECT()
Eg. if you have ='[April Data.xlsx]Sheet1'!$A$2 then change into =INDIRECT("'["&E1&"]Sheet1'!$A$2")
where E1 is

HTML Code: 

hope this helps