Copying data from one excel file to another

[BroodGeneral]

Hello,
I would like data appearing in one excel spreadsheet to appear on another excel spreadsheet automatically.

 

[arthurbr]

If the sheets are in the same book, click the tabs of the source and target sheet while holding down the Shift key if they are adjacent or the Ctrl key if not
Now the sheets are grouped and the target will reflect whatever you input on the source

 

[BroodGeneral]

Unfortunately the each spread sheet is in different books.