Automatically Populate cell based on worksheet name

I have a macro that copies data from 6 different worksheets into one summary worksheet - based on certain criteria - I need a way to note on each row of the summary sheet which worksheet it was copied from. Each worksheet is specific to a salesperson, so ideally I would like that salespersons last name to populate in column on the summary page for each line of theirs that is copied over....here is my current macro I use to copy the data: (this scrpit is repeated for each sales persons sheet - "Blankenship", "Dew", etc...)

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Oh, whoops.

Wrap your code, is what he's asking, it's the little shape that looks like a # sign.

Makes it a lot easier to read.

Please add code tags to your original post before anyone further responds

Thank you for updating the post...

Replies are now welcome.