I was wondering if there was a macro or a way to link large amounts of data together, Other than linking sheet to sheet on excel? Every time I switch files it takes an extremely long time to load, sometimes to the point of me thinking it has frozen.

Thanks.