Collect data from more sheets

Hello,

I would want to collect data from more sheets in one sheet, the sheets are all in the same (on line) folder.
Each sheet is used on a different computer, so let's say we have a sheet order, here are the total orders filled in, this is at the computer at the counter.
The next sheet is used in the computer of the kitchen, here they only need to see the basic information of the product that need to be cooked.
The fird sheet is used on the computer at packaging, here we want to see the order on order number.
The fourth sheet is used at the office to see total our and day transfers, also per product.

My problem is that I can't export information from sheets that are open on a other computer, or it works super slow.

Thank you

Originally Posted by FDibbins

I think you mean Files, not sheets?

What does the data look like that you want to pull in, can you show us what it would look like?

Please see attached, this is in basic what I would like to do.