Simple warehouse location management template

Dear Gurus,

I need your help.

I am trying to design this simple warehouse location management template for my business, such that I can quickly check my system and know where "what" is, and how many of it is in "what" location within my warehouse.

So I attached a sample template with worksheet rack names (Rack A, Rack B, Rack C...), and each of the Racks still have sub locations 1,2,3.... This means a rack has a unique code of A1, B2, C2, etc.

The products have unique codes which makes them different from each other, so whatever formulas we are bringing in will be based on these codes.

I want a situation where when I enter a unique code in the "Lookup Page" worksheet cell B3 (Example used is CK3 colored YELLOW in the workbook), cell C3 will display the description, and column A (from A5 downwards) will display all the rack numbers where the item is not zero in quantity, while column B (from B5 downwards) will display the corresponding quantities.

The working principle is, whenever I take anything out of any of the locations, I will subtract the quantities from that specific rack so as to ensure I always have accurate data.