Reference Other Sheet Through Variable

All,

Apologies for not using the proper syntax to describe my problem, I'm "self taught" (aka Google and trial and error). However this problem is stumping me.

I created the formula below to reference another worksheet.

=IF(SUMIFS('12.6'!$G$1:$G$2000,'12.6'!$F$1:$F$2000,$B$2,'12.6'!$E$1:$E$2000,$A4)=0,"",SUMIFS('12.6'!$G$1:$G$2000,'12.6'!$F$1:$F$2000,$B$2,'12.6'!$E$1:$E$2000,$A4))

While it may not be the most efficient approach, it does work.

My goal is to replace "12.6" with a variable so that I can update the formula on new sheets more quickly. For instance in the formula above there are 6 instances of '12.6'. I would love to have the ability to update one cell to say '12.9' and have the formula call on that cell to change all 6 instances.

Any guidance here would be great. Thanks!

You can use INDIRECT. If not

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks for the advice.