Auto populate with VLOOKUP

[Nanaia]

Is it possible to pull data from a second sheet and have it auto-fill without having to tell it specifically what to fill for? I know that's poorly worded but I don't know how to word it concisely.
I'm trying to create material cut sheets fed from a work order spreadsheet. Cut lengths vary and I would need one cut sheet per length that is actually used, and also list the order numbers that use that length with their quantities needed. I thought I remembered there was a way to pull only the sizes used using VLOOKUP but it keeps pulling every length, even the ones without a quantity next to them. Am I remembering a dream? Can this even be done?
Below is an example of the two tables I need to pull the data from. We use SEQ for the order number.

TABLE #1 FLAT SHEET LINE
SHEET TOTAL	SHEET
63	96	x 48
159	90	x 48
251	84	x 48
67	78	x 48
69	72	x 48
	66	x 48
609	TOTAL SHT
3,867.50	Linear Ft.

<tbody>
</tbody>

Here is table 2

SEQ#	# PARTS	# SHEETS	SHEET
1029	400	67	84	x 48
1030	400	67	84	x 48
1031	1100	69	72	x 48
1032	700	117	84	x 48
1033	800	67	78	x 48
1034	950	159	90	x 48
1035	1000	63	96	x 48

<tbody>
</tbody>

 

[mole999]

providing your reference is unique you should be able to retrieve. If say you used 64 & 64 elsewhere then only the first sorted value would be returned with VLOOKUP

 

[Nanaia]

Is there a way to get it to list the SEQ#'s? So as the reference tables are populated, the cut sheet cells would populate? For example, the 84" sheet would list SEQ 1029, 67 pieces, SEQ 1030, 67 pieces, SEQ 1032, 117 pieces? I can get it to create a line for every SEQ# listed and just be blank if the sheet size needed doesn't match the cut sheet, but I was trying to see if I could avoid all the blank lines between the SEQ entries. There are only 10 SEQ lines in this application for 6 cut sheets, but I have another one that has twelve cut sheet sizes and twelve possible SEQ#'s. I figured less irrelevant information is better for the operators.