lookup and create summary sheet from data in existing workbook using vba

Code/Help required on Excel VBA
I have an automatically generated workbook which forms part of a bill of materials which is generated from within an autocad drawing via vba. (see sample attached). This is only a small sample as some of these worksheets can contain many more rows of data. (Note the first 9 rows of the worksheet are auto filled by the same vba macro in Autocad to show project information from the drawing titleblock)
What i would like to do via vba is as follows
for every instance of 1,2,3,4 etc in column B i would like to automatically sum the corresponding values in column H.
Columns J,K,M,L & O are part numbers and for each pour number (1,2,3 etc) i would like to be able to sum the number of different items required. Note the Part numbers will vary on a pour by pour basis.

I suspect a separate summary sheet would be the best option showing the same project information on the top 9 rows then going into detail with the summary information for each Pour Number in the sheet BOM. I have created a basic example of what it could look like on the summary worksheet in the attached file.

I am not very experienced and have not used excel a lot in the past so would appreciate help in finalising my project. If anyone has some code they are willing to share it would be greatly appreciated. I am specifically wanting to use vba so that i can process the data to create my summary worksheet through my existing code

Regards John B