As per the attached file, I have an example bakery production plan. The bakery has (4) production lines and operates Monday to Friday.

There are effectively 4 x 5 named ranges I want to create on the "Week" tab.

On the "Report" tab I want to use a data validation drop list to call any of the named ranges including the (6) columns of data in the named range.

On the "Report" tab I can hard code one named range ("Simon_2"), but can't work out how to use a drop down list to call any of the named ranges plus the (6) data fields in that range.

Any assistance is appreciated.

Thanks

Shayne