Hi Ryan,
What you’re trying to achieve would be doable through an Excel file if you had to display only one location on your screen. You could have used a first collection with all location from a first Excel Worksheet, then, upon Location selection, show a unique Slideshow, by filtering by location a second Worksheet containing all the medias as it’s done in samples Restaurant Menu or Steel Frames Collection on Marketplace.
It uses a pattern we call “Master Detail”, explained in this dedicated article here.
If you want the exact layout you shown above,I recommend you to use a json file instead of an Excel file as shown here: How to use data between 2 nested asset grid - #2 by Alex
Regards,
Alex.