Schedule copy real-time data as values to new sheet

I need to copy real-time data to a new sheet automatically at certain periods throughout the day. New data is saved to a new column avoiding overwritten earlier copied data.

An example of what is needed is attached.

If there is lack of clarity in my sample please do let me know.

Thank you for your interest.

.
In Sheet Master module paste :

Please Login or Register  to view this content.

In a Regular Module paste :

Please Login or Register  to view this content.

Save workbook as Macro-Enabled.

Terrific Thank you

This first piece of code has given me a great base to work from. It now allows me to add functionality where it is needed.

I am very grateful for the help here.

Cheers

.
You are welcome.

Glad to help.