Dragging and Sumif to change the sheet name

[roc_ent]

I'm creating a page where the months are in cells A19 to A30. On ROW 18 I have different category headings like B18 is Advertising, C18 is Rent.
so what I'm doing is SUMIF in B19 and I've created the formula with relative cells to look in so my formula would be =SUMIF(Jan!$D$5:$D$94,"Advertising",Jan!$C$5:$C$94) but what I want to change when dragging is the Jan to Feb to Mar etc. All other information and references are working good. I'm doing a find and replace row by row. There must be a way to change the tab (or month) names.

 

[Fluff]

You could use the INIRECT function, although it's slow & volatile.

+Fluff 1.xlsm
	A	B	C
17
18		Advertising	Insurance
19	Jan	0	0
20	Feb	0	0
Master

Cell Formulas
Range	Formula
B19:C20	B19	=SUMIF(INDIRECT($A19&"!$D$5:$D$94"),B$18,INDIRECT($A19&"!$C$5:$C$94"))

 

[roc_ent]

Sorry Fluff, but for some reason its not giving me what I need. The long way is using Find and replace, so I drag down say "Jan" into the Feb cell then use find and replace the Jan and replace with Feb.

 

[Fluff]

Do you have the sheet names in col A as shown in my post?

 

[roc_ent]

no I do not. The tabs are Accounting, Jan, Feb, Mar to Dec and last sheet is the tables

 

[Fluff]

When you said

I'm creating a page where the months are in cells A19 to A30.

I assumed that you had Jan, Feb, Mar etc in those cells. Can you change those value so that they match the sheet names?