Creating a synthethis list of data based on multiple references

Hello, I'm basically trying to go from table 1 to table 2 below:

ITEM INVOICE NUMBER BALANCE DUE
TABLE AAA £500.00
CHAIR AAA £150.00
CUTLERY CCC £250.00
MIROR BBB £200.00
TABLECLOTH AAA £220.00
PLATES CCC £520.00
GLASSES CCC £500.00
BOOKS BBB £450.00
ARTWORK BBB £150.00
VASE AAA £250.00



INVOICE NUMBER BALANCE DUE
AAA £1,120.00
BBB £800.00
CCC £1,270.00

The table 2 will be on a different worksheet and basically I would like it to find out autmomatically the invoice numbers without me having to enter them Is this possible?