Automatically update formulas

[VickyOakman17]

I am trying to find a way in which I can add a new worksheet each month or every two months, to a workbook, and the formulas will automatically update to the previous worksheet.


For example I have a Jan 2023 worksheet but then add March 2023- I want to following formulas if possible to update to the 'Jan 2023' cells not the 'master' cells. Without me having to manually change them.

=SUM(K32-Master!K32) would now need to be =SUM(K32-'Jan 2023'!K32)


Is this possible to do using a macro or VBA.

 

[ExceLoki]

try this
------------------------

create a sheet or somewhere for a list of all the sheet names to be

define name and put the following into the refers to field:
=replace(get.workbook(1),1,find("]",get.workbook(1)),"")

Book1
	A	B	C	D	E	F	G
1	Sheet Number	Sheet Name					21
2	1	Sheet List				Result	5
3	2	Dec 22
4	3	Jan 23
5	4	Feb 23
6	5	Mar 23
7	6	Apr 23
8	7	May 23
9	8	June 23
10	9	July 23
Sheet List

Cell Formulas
Range	Formula
A2:A10	A2	=IF(ROW()-1<=COUNTA(IFERROR(INDEX(SheetList,C1),"")),ROW()-1,"")
B2:B10	B2	=IFERROR(INDEX(SheetList,A2),"")
G2	G2	=SUM(G1-INDIRECT("'"&VLOOKUP(MAX(A:A),A:B,2)&"'"&"!"&"h1"))