I know that Excel can store up to as many scenarios as you have memory
for - but is there a way to access the data across scenarios all at
the same time?

Trying to create a single file for forecasting - each scenario would
represent the results from a specific time period, but it would be
nice to make comparisons across scenarios easily.