Make a list that auto-populates data

I'm working on a workbook with 2 tabs. The intent of this workbook is to create a order list based on what is entered.

What I'm trying to achieve is the following:

• In TAB 1 all information has been populated except QTY. I would enter a number (my numbers below in red) under the QTY column. Note I would not be putting values on all rows.
• Then, in TAB 2 it would auto-populate all the same information but starting at the top of the list, per the order it is in TAB 1.

I'm keeping TAB 1 and TAB 2 separate since one will have a master material list where information will be added and edited. The other tab is what we would use to give to our procurement agent, who we don't want to confuse with the master list and a lot of blank QTY cells.

I imagine 'if' statements and vlookup would come into play here but I just can't wrap my head around it. Any input would be appreciated.

This is a spreadsheet that would also be shared on Teams. Not sure if that would affect anything.

TAB 1

TAB 2