Excel Automation – Generate RA Bill Automatically from Measurement Sheet

I already have an Excel system with a Measurement Sheet (input) and Dashboard.
I need a small automation to generate an RA Bill sheet automatically from the measurement data.
Requirement:
RA Bill should be generated automatically based on the selected RA number.
Each Item No. should appear as a heading with its BOQ description.
Under each item, the measurement rows should appear automatically from the Measurement Sheet.
The table should have these columns:
Description | Unit | N1 | N2 | Length | Width | Depth | Qty
The Description column should show location/sub-item from the measurement sheet.
When entries for the same Item No. end, the system should automatically show Total Quantity.
After the total row, the next Item No. section should start automatically.
The number of rows under each item should depend on how many entries exist in the measurement sheet.
Example Structure:
Item No. 022040
BOQ Description
Description | Unit | N1 | N2 | Length | Width | Depth | Qty
Location A
Location B
Total Qty
Item No. 025031
BOQ Description
Description | Unit | N1 | N2 | Length | Width | Depth | Qty
Location A
Location B
Total Qty
Important:
Measurement Sheet already exists (data source)
RA Bill should update automatically when new measurements are added
Should work in Excel / WPS Office