I have set up a spreadsheet which required data from another spreadsheet and
want to know how i can set this up to update every time i open the sreadsheet.

I want the full page of the source data copied accross to a worksheet in my
main excel file.

Can anyone help? It is a macro code i need?