Trying to Populate a Data Sheet Quickly (Beyond My Abilities)

Hello all,

I am trying to populate an spreadsheet that I do about 20 times a year (about 100 others in my company do this the same amount I do). The process is extremely long and tedious, and a lot of information that has to input by hand now could easily be auto populated.

Attached is the excel sheet I am trying to use, some notes with this:

- The "Data Dump" tab is exactly how the report comes out of our system (there is no way to change this).
- The "Data Dump" tab is only part of my project the list goes on (and would like it to work no matter how many lines there are)
- The "COST REVISION" tab is what my company currently uses (this can probably change a little, but not be accepted by my company with any major changes in looks)
- The "BILLING ADJUSTMENTS" tab is not needed for populating
- There are a lot of duplicate "Unit Codes" but only if they are in different "Project WO#"s
- I have color coded what information I am looking to auto populate on both the "COST REVISION" and the "Data Dump" tabs:

- Yellow is the "Project WO #" All that is needed is the characters before the first space (rest I would like to not auto populate)
- 25% Darker Orange Accent 2 is the "Unit Code" All that is needed in the characters before the first space (rest I would like to not auto populate)
- 25% Darker Blue Accent 1 is Budget Unit Quantities
- 25% Darker Blue Accent 5 is Budget Man hours
- 40% Lighter Blue Accent 1 is Budget Cost
- Lavender is Actual Unit Quantities
- Light Purple is Actual Man Hours
- Dark Purple is Actual Cost
- Black (with white font) is the criteria I would like to run this report from (discussed below)

Basically what I would like to see happen:

1. Create a new set of boxes for each "Unit Code" and "Project WO #" we have (I.e Rows 18 to 23 on "COST REVISION")
2. Auto populate the following information for each "Unit Code" and associated "Project WO #" from the "Data Dump" tab to the "COST REVISION" tab: Project WO #, Unit Code, Budget Unit Quantities, Budget Man hours, Budget Cost, Actual Unit Quantities, Actual Man Hours, & Actual Cost
3. Have a button or a way to delete all the ones that do not fit the criteria that I select on the "COST REVISION" tab (in Black with White Font Cells: T5 & T6)
4. I also need a way to add up all the information like to rows 210 to 215 of "COST REVISION" tab
5. Have some way to add set of boxes for the Unit Codes that do not match the selected criteria but are still needed to add to the revision

If someone could help with this it would be greatly appreciated and will save me a bunch of time.

Thank you,

Sean O