Report Generation In Worksheet B Using Worksheet A

I have 2 worksheet A for data capture & is looking for a VBA to create a report in worksheet B using worksheet A. How the VBA should look like?

Worksheet A
Container Type
Type of Seafood
Weight (kg)
Ave price $/kg
Price ($)

Container A

Fish

1

5

5

[Code] ........

Worksheet B
-contains X number of table, one for each container in worksheet A.
-there should be a sub total at the end of each table.
- one final grand total at the end of report.

Container A
Type of seafood
Weight(kg)
Ave price ($/kg)
Price ($)

Fish
10
50/10 = 5
10*5 = 50

Prawn
6
30/10 = 3
6*3 = 18

SubTotal
$68

Container B...

Container X....