I maintain weekly time reporting worksheets (within a single Excel file) and want to combine them into one worksheet in order to summary information over the year.
The column headings from each sheet are consistent.
I would like to capture the sheet name as a new column in order to differentiate the data once combined.
Attached is a sample.
Thanks for your help,