Looking to have numbers corrected and accounted for

I have an excel sheet with sales data that I had sorted and summed. The data got corrupted so I need osmeone to go in and retabulate the "Main Sales tab". I want the raw data from the "Original data" tab, only date range 9/2/2018-9/3/2019 represented on the "Main sales tab" page. The columns on the "Original data" tab are column G - vendor part # and column F [login to view URL] is the only data I want represented on "Main sales tab". When you look at the Main sales tab you will see the data is organized in two area. All of the data should be in the section below V127 Door totals. This should be all of the "Vendor part #'s" sorted by product type from the original data tab. I need all of these numbers repopulated with new totals from the original data tab because I no longer know what products are accurate or not. Then I need the data to also show up next to the Vendor part # in column D. So the data under V127 should be every model number from the Origianl data tab while the data in Column D6 through F116 is a summary of some of the vendor part numbers on the list. So this project is to give me corrected quantity/ sales numbers for each vendor part #. If there are any vendor part numbers that do not show up on my list in the main sales page they should be put onto the tab "missing vendor part #'s" I will determine what to do with them after. These items that go onto this tab should have all of the info in the row on the "Original data" tab. I am lookin gto have this back very quickly as I need to be working on it.