Files vs tabs

[Harley78]

I have a question which is better, separate tabs or files? Heads up, Sorry for being long winded

My main report (Parts Daily Status Report) I copy and past rows/columns from the Balance due report. I pull data from other files so I just need to look on this report only and update only the others. I am using many Vlookups across the files as well as formulas. Wouldn't think this would be a problem however, it seems to create issues I do not like to see. Causes a slowdown (Spinning) and crashes.

Steps:
File 1: Parts Daily Status Report I copy and paste columns rows from the beginning of the day as this changes daily from the current Balance due report. I have Vlookups on this report as well, pulling data from Freight and Dispo ****pit reports
File 2: Freight report looks at goods receipt report using a vlookups to determine if it arrived how many and when Formulas that determine the transit times. I update this daily with orders that have been shipped by the supplier.
File 3: Goods Receipt Report I copy and paste what was received day prior from another report I run from SAP
File 4: Dispo ****pit report form SAP, is copied and pasted to its own report

So to get to the question. What is the best setup? To combine files into one file using tabs or keep them separate into file? Is copying pasting updated info to all the files causing issues? just wondering why it crashes and slows down the update (Spinning)

 

[Harley78]

I also forgot I have another file with Parts information that updates the Freight file with weight. So I would have 6 tabs in one file or 6 separate files. I would assume that it would be best to go tabs but that is a lot of vlookups and data in one file. Just wondered if anyone has any suggestions and or experienced this and what the fix was?