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="width: 138"]
<tbody>[TR]
[TD="colspan: 3"]TABLE #1
FLAT SHEET LINE
[/TD]
[/TR]
[TR]
[TD]SHEET
TOTAL
[/TD]
[TD="colspan: 2"]SHEET
[/TD]
[/TR]
[TR]
[TD]63
[/TD]
[TD]96
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]159
[/TD]
[TD]90
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]251
[/TD]
[TD]84
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]67
[/TD]
[TD]78
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]69
[/TD]
[TD]72
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]66
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]609
[/TD]
[TD="colspan: 2"]TOTAL SHT
[/TD]
[/TR]
[TR]
[TD]3,867.50
[/TD]
[TD]Linear Ft.
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Here is table 2
[TABLE="width: 234"]
<tbody>[TR]
[TD]SEQ#
[/TD]
[TD]#
PARTS
[/TD]
[TD]#
SHEETS
[/TD]
[TD="colspan: 2"]SHEET
[/TD]
[/TR]
[TR]
[TD]1029
[/TD]
[TD]400
[/TD]
[TD]67
[/TD]
[TD]84
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1030
[/TD]
[TD]400
[/TD]
[TD]67
[/TD]
[TD]84
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1031
[/TD]
[TD]1100
[/TD]
[TD]69
[/TD]
[TD]72
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1032
[/TD]
[TD]700
[/TD]
[TD]117
[/TD]
[TD]84
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1033
[/TD]
[TD]800
[/TD]
[TD]67
[/TD]
[TD]78
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1034
[/TD]
[TD]950
[/TD]
[TD]159
[/TD]
[TD]90
[/TD]
[TD]x 48
[/TD]
[/TR]
[TR]
[TD]1035
[/TD]
[TD]1000
[/TD]
[TD]63
[/TD]
[TD]96
[/TD]
[TD]x 48
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.