Help with a dynamic filtering table

Hello everyone. I work for a engineering company and I have this large excel sheet that is a dynamic filtering table. SO that works just fine. It's very large and intellectual property so i cant put it up but here's what the layout is like:

List (filter) - model number variable (filter) - variable a - variable b- variable c - variable d - variable e, etc
**filtered options below

So if I want a specific list variable and model variable to achieve variables a-e, I filter it and then I get what i needed. That's all dandy however i want that one row of the needed variable and options chosen to populate in a different sheet in a table respectively. This is important because this the sheet that does a million calculations and formulas.

What I have tried so far hasn't worked, "vlookup" "filter" "power qeury" etc... even just "='thatsheet'!cell

Anyone know how to make this work anytime I filter everything down to the one model I want. Remember that the cells change every time I narrow it down to that one model.

THANK YOU>
excuse all grammar mistakes, I'm lazy...

I WILL IF NEEDED OUT A SAMPLE OF THE LIST, BUT ITS A PRETTY STRAIGHT FORWARD FILTERED LIST