Excel - transfer information from file

Hi there!

I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of information which I want to split into two seperate files, however, I want to keep working in the "big" excel sheet and hopefully the two other sheets will get automatically updated...

I have tried the "copy sheet" function, but this doesn't enable me to copy certain rows and columns of the "big" Excel sheet.

I hope it makes sense to you Excel wizards :-)

Looking forward to getting my hair back....