Xlookup from another page in Google Sheets

Hello, I'm a novice user and trying to make a spreadsheet to help with work, using multiple conditions from an order to generate a list of needed parts. I'm getting an error when attempting to reference data from a drop down on another page.

I've attached a trimmed down example that I can share without posting work info.

https://docs.google.com/spreadsheets/d/1UT6k7b7Sqi0mV6L867CS_jSVQXN15ZyDkHa3gPlTgrg/edit?usp=sharing

The real document has more of basically variable, but I think part of the complexity problem is the part numbers I'm trying to generate use the inputs in different ways and in different orders for each part, so I'm trying to make a page for each kind of part data and keep a cleaner UI page.

There's probably a cleaner way to do this, that may or may not work with all the actual inputs I need to do, but I'll take any and all advice, I'm just a novice at best.

Thank you.