Formula for Top 50 Sales By Item Number

[freshpro3285]

I have a workbook with 2 tabs

1st tab = Top 50 sales by item code
2nd tab = Open Orders w/amounts and item codes

I need a formula that will pull only the item codes listed on the 1st tab from the Open Order tab. My Open Orders tab contains over 3,000 different item codes with 1000's of rows and I only need the 50 with their corresponding amounts.

Make sense ??

Any help would greatly be appreciated.

 

[freshpro3285]

I forgot to mention one last minor detail. I need the amounts from the Open Order tab to roll up into weeks. So I need a formula that would identify the item codes listed in the 2nd from the 1st tab and roll up the amount into weeks.