I am trying to copy a list of film titles I have in one worksheet contained
in one workbook to another worksheet in another workbook. There are no
formulae involved, it is not a mathematical process, simply information.
There must be a link between the 2 worksheets so that any changes in the
original are reflected in the destination worksheet. I have tried linking
and paste special, but nothing seems to work. I am convinced this is because
I have not fully understooed the processes involved. Can anyone tell me
which is the best option and then give me a detailed step-by-step method of
how I can achieve what I want?

Many thanks

Gareth