compiling/pulling data (range) in different files into one file

hi there,

I have a number of sheets with the same structure but different data. I need the information to sit in the different files for multiple users to be able to update it. Can someone please help me with a solution for compiling/pulling the data ranges in the different files into one file automatically. The ranges may vary although I could set a buffer in the ranges.

Please help.