Usually when referencing a tab name in a formula, we'd use:
Or, in my sheet (attached), since my tabs are named for dates:
On the main tab are SUMIF calculations, a new date for each column. Since each date will also get a new tab of data (to be summed), I'd like the formulas to account for the dated tabs. Rather than hard coding 'Mar-15' or 'Mar-16' or 'Mar-...X' into the SUMIF formulas, looking to reference the dates in the column headings in 'Main tab'.
Can this be done?