From your management accounts spreadsheet select the "Reference Table"
Filter the columns by the various sales departments (SALES-NEW, SALES-USED & SALES-DEMO for example) also filter the column by "Type" of SALES and "Nominal Description" of VEHICLES
Select the entire lines and columns and right click and copy the selected table.
Click into the "Units" tab and paste the selected data into that tab.
Your units tab should look like the below.
Before going into your "Control" tab to "Recalculate" remove all of the filters applied in the first step within the Reference Table"