Excel Data Manipulation (Sort & Copy)

I need to copy data from one excel worksheet to several others. 1) All the Data to be copied from (Source) is on the "Copy From This Sheet" tab - Need to copy based on the part number column. - the only data from each row that needs copied is part number, description, list price, qty, Desc(%) - Note that these column locations likely will NOT change, so can use column reference. 2) The part number for each row needs to be checked against the sheet named "part numbers" and sorted to tabs based on that list. 3) There are twenty (20) sets of tabs (called 1 - 20) though the attached sample only has two sets created for reference. Each set contains three "types". - Each type is used for sorting. - Type B is for anything that is found in the type b column in the "part numbers" tab. - Type C is for anything that is found in the type c column in the "part numbers" tab. - All part number NOT classified on the "part numbers" tab, go in Type A. 4) When parsing the data to copy, if there is a blank "part number" cell in a row, that starts a new "tab set" - up to twenty. See notes in the spreadsheet as well. **Match DESTINATION styles. Data should ONLY copy into the tables.... **The tab naming follows the same scheme for all 20 sets. **Code must be commented to note functions/steps from high level.