I am basically trying to copy data from one sheet to another within the same
workbook. My problem is that it is dynamic so the columns basically get
updated everyday, the data within the worksheets are not overwritten but
simply appended, so whatever data that is already there has to stay there. I
want to basically copying from 2 cells in worksheet A and 1 cell from
worksheet B onto 3 cells within the main worksheet, if anyone can help me
with this it would be greatly appreciated,

Thank you