The work book will contain one sheet from another workbook. If possible i need all the information copied across, showing the data from the source.
If when i come to update the original sheet would it be possible to set it up to automatically update the sheet copied across?