Moving a List to A Table?

I have a list of document locations by the cubby hole. I want the same info to show up in a diagram (table?) on a separate worksheet that I can print out and tape to the wall next to the cubbies. Attached should be an example - part of my list and the way I want the cubby diagram to look. When I type in a document name and location into the list, I want it to show up in the right cubby on the diagram.

Can I do something similar between workBOOKS and not just the workSHEETS?

Thanks!!!!

I think the easiest way to do this is turn your main table into an Excel table so that we can write formulas that will automatically include any new rows you add to your main table. You can then use the following formula in G4. Please note that it should be array-entered (Confirm with Ctrl + Shift + Enter instead of Enter).

=IFERROR(INDEX(Table1[[Name]:[Name]],SMALL(IF(Table1[[Cubbyhole]:[Cubbyhole]]=G$3,ROW(Table1[[Cubbyhole]:[Cubbyhole]])),ROW(1:1))-4),"")

Fill right through K4. You can then use the exact same formula for G6 and G8, just change the G$3 in the middle of the formula to G$5 and G$7, respectively. Similarly, change the middle to N$3 and you can use it for your "D" cubbies in N4. Fill it right and down for the Ds. Make the same adjustment in the middle for your other cubby subsections. If you want the resulting layout on a different sheet, just copy and paste it to a different sheet. You should be able to copy and paste it to a different workbook, as well.

The attached workbook should give you a clearer view of how the formulas look: