I have two files. Each file has the same content.

File 1 - Moves very quickly, does not lag for calculation. In this file, the data mentioned in the subject line is broken into approximately 6 separate tabs by city (there are hundreds of buildings within a city).

File 2 - Moves very slowly, lags significantly for calculation. In this file, the data mentioned in the subject line is combined into a single tab.


I'm looking for confirmation that tabbed data helps performance, even though it's the same amount of data within the file.

I would prefer if my data were combined in 1 tab, because it will be less manual for me to maintain and ensures I'm capturing 100% of the content. Tabbed data would require me to ensure that if a new city (or new buildings within a city) gets added to my data set, I would have to create an additional tab, or would have to ensure my formula rows get dragged down to capture the raw data.