Copying multiple worksheets into one Summary sheet with VBA

[tfagan1978]

Hi all,

I am hoping someone can help me with some VBA code that I need. The file attached has 3 tabs in it. I have a VBA code in the workbook that takes the data from all 3 worksheets and puts it into a Destination sheet that gets named 'Adjustments'. The only problem I am having is that I don't want row # 1 and 3 to be copied over from the NAP DC2 worksheet. I also don't want row # 1 and 2 to be copied over from the OUT DC2 and I don't want row # 1 and 2 to be copied over from the MRP DC2 worksheet

Then I would like the code to insert a new column 'A' on the Adjustments worksheet, and in all of the cells that were copied from each respective sheet, I want the first 3 characters of each respective sheet name to be put into the new column 'A' alongside the data that came from each sheet.

Basically I need to know what rows came from the NAP DC2 worksheet, the OUT DC2 worksheet and the MRP DC2 worksheet

Then if possible, I would like the NAP DC2 sheet, the OUT DC2 sheet and the MRP DC2 sheet to be deleted so that I am only left with the Adjustments sheet

Any help would be greatly appreciated as I am very new to VBA and have no idea how to do this

Thanks,
Tom

[walruseggman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[tfagan1978]

Sorry for the non compliance on my post. i have renamed my post to be more in line with what I am looking for