4 way dependent dropdown/data validation

Your posted sample doesn't lend itself to your query. Why not post a sample of your actual data?

However you basically need a unique list to base the solution on, I have chosen Column "Manufacturer" for this example.
The Data Table should be Sorted/Grouped on the chosen column.

See the defined names in the Names Manager to see how the dynamic names are built.

Select from the drop-down in sheet "Pricer" Column "Manufacturer", then from the drop-down in "Application Method"

This might give you a start, it won't in itself solve your problem.

With a database of some 5000 rows I would avoid using the volatile function OFFSET() when defining names, use INDEX() & MATCH() instead.