I run a weekly report that tracks revenue and work orders. From the raw report I pull data and compile it and break it down further on a per employee basis. I have the basic formulas down for the data I'm pulling from the raw reports, but the issue I'd like to overcome is that each column's formulas need to pull from a different weekly report (each on individual sheets). The bulk of the formula would remain the same across the rows, but the reference sheet would need to change on a per column basis.
My table header for each column is already named the same as each sheet it would be pulling from, but I cannot seem to implement the indirect() function properly.
Here is a sample formula that I'm currently using where I'd like to convert the "'week 1'!" Reference to an indirect () function that looks up the sheet name which matches the column header.
=SUMIFS('week 1'!H:H,'week 1'!B:B,'2021 Revenue'!A4,'week 1'!F:F,"Sold")
Any help would be greatly appreciated.
