Hey guys, I'm merging 15 days worth of time tickets into one master sheet which I then use to prepare payroll for the period. I've found code that performs this operation, however, there's one critical piece of information missing. When each day's data is dumped onto the master sheet, the code fails to help me identify which worksheet the data is coming from.

I want to alter the code so that when each day is 'dumped' onto the mastersheet, it either breaks up the days with a blank line (after which I can manually input the dates), or even better, references the worksheet which the data came from. This would simply require displaying the sheet name the rows are being pasted from into a new column on the outside of the range for each row of data.

Any thoughts?