VBA to build table based on 2 spreadsheets

[JamieT]

Hi Guys & Gals - I really need some with VBA. I have two spreadsheets and i need to build a table out of them.
First spreadsheet tells me which builds are against which equipment numbers (the builds are the A numbers across the top)

Eq No.	A465	A506	A507	A508	A510	A511	A514	A525	A561	A557 (mm)	A560
96550153		1				1				900	1
96550157				1
96550158				1
96550160					1
96550162				1
96550163					1

<tbody>
</tbody>

Second spreadsheet tells me which spare parts and quantity are against which builds

Part No	A506	A507	A508	A510	A511	A514	A515	A516	A525	A557	A560
BAA47259		2	3	5						3	2
XLA0617		1	2	1		2			1	1	1
BAC1718		1	1	2						1	1
BAE3982	2	2			1		1	1

<tbody>
</tbody>

However I need to figure out how to make a table of equipment numbers and associated spare parts with sum quantities.

eqnum	part no	Qty
96550153	BAE3982	3
96550153	BAA47259	5
96550153	XLA0617	2
96550153	BAC1718	2

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Can anyone help? It doesn't necessarily have to sum the quantities, it could repeat part numbers with different quantities and then i could put it into a pivot table to get the quantities summed and remove the duplicate part nos.

Really hoping someone can help me - This seems impossible.