Dynamic map for warehouse bin locations

Hello!

Data I have:
around 4000 bin (pallet) locations. Let's assume they are just numbered 1 to 4000. Each location number is connected with its volume. There are only 7 types of volume, let's say the volumes of bin location are named A,B,C,D,E,F,G.
I have also around 30 groups of SKU (stock keeping units). They are just different words.

What I look for?
Dynamic warehouse map with bin locations by groups or by SKUs. I need to arrange the layout to fit specific number of SKU or number of types to 7 available volumes. Important fact is the number of bin locations inside each volume is different, limited but known. So there are in example 1000 locations volume A, 450 locations volume B, 1300 locations volume C and so on.

Let's assume I have 4000 SKUs that can fit specific bin locations volumes.
So in example I have data like:

SKU: ZYX 545, can fit location: D, group: trousers
SKU: XYZ123, can fit location: B, group: t-shirts

Ideally the idea is to represent each volume A,B,C,D,E,F,G visually using colours and each group using numbers in cells. Excel should update number of places left by volume, by group and by SKU each time I change my warehouse layout (or rather group layout).
I should have ability to drag and drop each group where it can fit.
It's something like heatmap, but instead of rotation - groups and locations they can fit are the variables.

Let give a start by a sample worksheet to see what to keep going.

please see attached

colours represent volumes of bin locations (A,B,C...)
cells represent bin location
numbers represent bin location addres (which is linked in data I have with location volume), please refer only to blue aisle for correct location addres example
groups are not marked here but should be marked probably also with a colour to see how much space they need in each aisle and each location volume