I have a worksheet that extracts live data to a column at regular time
intervals set by the user and is continuously updated.

How can I transfer this data to another workbook/worksheet wherby time
could be reproduced along the horizontal axis and the other data reproduced
on the vertical axis?

Would one use the timer function within VB code, or is there a simpler way,
whereby I could paste each fresh set of new data into a new column in a new
workbook/worksheet in order to create a graph simply?