reformat large spreadsheet to consolidate information

I am looking to take a huge spreadsheet (customer list with services, pricing, etc) and consolidate into a more concise spreadsheet for audit purposes.
I've attached a sample set showing what I want to do and the types of information.
Main thing, the INPUTS have multiple lines for one customer with a different service/price on each line.
I want to move the information to a new spreadsheet, consolidating the multiple lines down to one line for each customer, automatically.
There are several IF's and LOOKUP's that will need to be done. I'm pretty good at editing code to fit my needs, but getting started is the issue (not great with syntax on a blank vba project).

Maybe there is a way to do this with formulas versus VBA??