I am working to extract all relevant data from one worksheet to another based
on on common field in main sheet.

for example

main sheet
check # 999999

invoice sheet with check disbursements
invoice # check #
12345 999999
12346 999999
12349 999999
of course there are other invoices and other checks mixed in here as well

how should this be set up, so i an extract this.

thanks