Formula that pulls date from other tab, but tab selected can vary?

[usnapoleon]

Hi all.
I know linking a formula from one cell to another in a different tab is super easy, but I was wondering if we can do anything to make the selected tab change based on the desired month.

I have 1 tab for each month. The data will be in the same cell location for each month (monthly tab layouts are the exact same).

I could always make the basic linking formula, and just do a 'find & replace' and have the tab name edited for each month but there can be something cooler I'm not thinking of. Any idea?

Here is the tab where I want the formulas:

2024 Golf.xlsm
	A	B	C	D	E	F	G	H
16
17
18	DATE	DESCRIPTION						AMOUNT
19	3/1/2024	TS Mktg. Golf & Theater						TSMRWV
20	3/2/2024	TS Mktg. Golf & Theater						Golf Rounds
21	3/3/2024	TS Mktg. Golf & Theater						-
22	3/4/2024	TS Mktg. Golf & Theater						-
23	3/5/2024	TS Mktg. Golf & Theater						-
Invoice VOGOUT

Cell Formulas
Range	Formula
B19:B23	B19	=$A$11
A20:A23	A20	=A19+1
H19:H23	H19	=Mar!G5

Here is an example of 1 of the monthly tabs where the data is pulled from:

2024 Golf.xlsm
	A	B	C	D	E
1	TOTAL POSTED TO ACCOUNT
2	TS Mktg, Golf & Theater - Room #7605
3	January-24
4
5		VOGOUT
6	Date	Foot Golf	Golf for 1	Golf for 2	VOGOUT Folio Total
7	1/1/2024				-
8	1/2/2024				-
9	1/3/2024				-
10	1/4/2024				-
11	1/5/2024				-
Jan

Cell Formulas
Range	Formula
A7	A7	=A3
A8:A11	A8	=+A7+1
E7:E11	E7	=SUM(B7:D7)

Tab names are
Jan
Feb
Mar
etc.

I was thinking about possibly having a cell where I'd type the Tab I want to use and it just automatically pulls from that selected tab. I just cant think of 'how' to do it.

 

[Joe4]

If I understand what you are asking, you should be able to use the INDIRECT function to do what you want.
See here: Indirect named range different sheet

 

[usnapoleon]

If I understand what you are asking, you should be able to use the INDIRECT function to do what you want.
See here: Indirect named range different sheet

Perfect!! I had to find something that broke it down easier, but pointing me to Indirect was the way to go, thank you!!!!