Sheets for warehouse bays update based on products in master list

Hello, I have two spreadsheets I am hoping to combine into one and have to only update one part.

One sheet is an alphabetical list of the products in the warehouse with a list of bay locations next to it.

IE ITEMX CB11 CB21 CB31

Each aisle then has a sheet which is a visual diagram of the bays within the warehouse. Each cell corresponds to a bay. So each cell will have a product despcription written in it and underneath will be the name of the bay (CB11, CB21)

What I would like is to only have to update the alphabetical list and then the 'Map/diagram' pages to update themselves.

I hope this makes sense and somewhere someone knows a formula to achieve this. Thank you.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Formula help" does not tell us about your specific question. I have updated it for you this time because you are a new member. --6StringJazzer