The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe