Macro to lookup in a workbook and append it to a table
 

I am very new at VB and need to create a marco for excel

I have the following situation:
A workbook with an unknown number of sheets. The first sheet is my summary
table which has 2 columns and a variable number of rows. This table contains
item# in column 1 and column 2 is for amounts (this column is blank).
Sheet 2 onward has tables of varying sizes. Column 1 contains item # and 2
contains amounts. There a more columns but those are not important. Some rows
contain no item #.
The macro needs to:
Look through all sheets starting with second one find item # matching the
ones in the first sheet then copying over the amount to the first sheet next
to the matching number. It is unknown on which sheet which item numbers will
be present and the code needs to go through all the sheets. The tables are
unsorted and can not be sorted.
Can anyone help me with this?