Merging: displaying which sheet data comes from when merging sheets

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?

I've just started to learn about macro's and vba, mostly from reading threads off this site.. Is there a simple command to display a string variable?

what if i wanted to output the worksheet name in a cell on a new sheet rather than displaying it in a message box?

and what if i want this to happen for somewhere in the neighbourhood of 200-500 lines of data that get merged onto the master sheet? would it help if i were to throw the code I've already gotten up? thanks for your

i want to tag the sheet name itself, as each sheet represents all crew activity for the day (i have 15 or 16 sheets, one for each day in the pay period)

zed commander,

If you upload a small sample file, dummy data is fine, with before/after format (need to be correct sheet layouts), it will help understand your problem better.

you are a fantastic individual. keep up the good work, here's some karma