I have 13 sheets, 1 of which is a summary sheet that references data with sumif formulas. I need to set this up for for over 100 workbooks with a similar format..
Sheet Names are Listed in Row 1 of the Summary Sheet as shown below.
Summary
1-Jan
2-Feb
3-Mar
4-Apr
5-May
6-Jun
7-Jul
8-Aug...