Needing Help with Matching

Good Morning All,

I'm needing help determining the formula I should be using. My problem is that I have two lists of part numbers, one is what I need and the other is another entities inventory. Their inventory is separated on different pages by building location and then location inside the building on each page. Their information is broken down into 9 columns: Part#, Name, Unit of Issue, Batch, QTY, Price, Total Price, Location, Date Received. I'm trying to determine the best formula to use if I want to match my part numbers to theirs and then output their entire row onto another page. Any help is very much appreciated.

Apologies for not reading the big yellow boxes above the thread. Here's a sample of the workbook.

The first sheet, "Parts Req'd", is a list of part numbers that we currently need. The second sheet, "Parts Request", would be the output of the matching part numbers. If I paste a list of 150 part numbers onto the first sheet, it would search for the numbers on sheets 3-8, column A. If there's a match, then output the entire row to sheet "Parts Request". I have an example on the first two pages. Currently, I use CTRL+F and have to search each part number, select that row and copy paste it onto the "Parts Request" sheet and make sure the quantity they have will satisfy my request. Most of the time they will have multiple rows of the same part stored in different areas. I have to use the find function and find enough parts to satisfy my request. In the updated workbook, I need 21 Washers. I copied over 4 rows from their sheet and pasted onto mine and adjusted the quantity to what I need.

After looking further at more formulas, would it be easier to use the FILTER formula? The array being the numbers listed on the parts required sheet, filtering only the numbers that match in column A on the CL IX sheet and showing the results on the parts request sheet. Is that possible?