Auto Fill in for List - based on another cell's value

Hi!

I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different for each section and sometimes they will all need to be the same.

Essentially, I want to give an override button where if turned on, the selection in this first list will filter down to the lists below OTHERWISE, if the override is not selected, the list will show.

I have the override section and list completed. I just cannot figure out how to create an IF statement that points to a cell value OR a list.


I am not sure how to include an excel sheet in this but pretend the dollar amounts are lists that show multiple values to select

Master Override
Yes
Limits
$100,000/$100,000

Part A
$250,000/$250,000

Part B
$100,000/$100,000

Part C
$100,000/$100,000

Part D
$100,000/$100,000



If Master Override = 'Yes', Part A, B, C, D = Limits



Is there a way to do this?

Thanks!