Is all the filters option is "show only relevant values". If not kindly check that option so that you can see the filters automatically updated based on the selection
"show only relevant values" is selected for all the filters.
I appreciate your response.
I have my worksheet filters set up as suggested, but the filters Promo, Order, Part on Sheet 3 are still not working correctly.