Copy sections from several tabs and paste as lists on one tab

[razkowski]

Hello-

I'm trying to figure out how to copy sections of information from several tabs and paste into continuous vertical lists on one tab. I've attached a sample spreadsheet: I'm looking for the macro to cycle through the "Manager" tabs copying the color coded information and pasting it to the "Import Template" tab in the corresponding color coded columns. As it pertains to copying, the macro should ignore the "Summary" and "Import Template" tabs and only copy from the Manager tabs. Also, you'll notice that the way data is entered into the manager tabs can vary: some are nice clean lists with no blank rows. Others can have blank rows in the middle of the data. Some are missing one piece of information in an otherwise data entered row. If the row is completely blank (zero balance), the row can be ignored. However, if the row is partially data entered and simply missing one piece of information, I'd like it to copy the color coded cells, even if it's blank. Perhaps a trigger can be if "Empl Total" (Column R) is not equal to zero, copy the relevant data in that row, even if a cell is blank.

I wish this was more simple but the data is entered by field people who are, shall we say, not very spreadsheet/computer savvy.

I greatly appreciate any help that can be provided. Thank you.

[razkowski]

I've attached the vba I've come up with so far but I'm definitely not there and still need help.

I appreciate any help that can be provided.