Sumifs: change summed data automatically

Hello everyone,

I want to automatically swap data in a column to sum it.

I have 3 sheets:

- Sheet 1 is a data sheet: in each column there are different information to log.

- Sheet 2 is a specification sheet: example: Information 1 in sheet 1 is "car registration", in sheet 2 there is a table listing all the car registrations with their specifications: weight, fuel burn, power, mileage etc.

- Sheet 3 is a dashboard where I have all my sumifs formulas

For now, in sheet 1, I have a column for each specification, and in sheet 3 I have sumifs formulas for each specification.

I want to simplify sheet 1 by keeping only the registration column but keep summing the same data in in sheet 3. To do that, inside the sumifs formula in sheet 3, I need a way to swap (for each row) the car registration (sheet 1) by the desired specification (sheet 2) of that car registration.

Any help will be appreciated

Thanks