You need to clarify your explanation. Maybe provide an example or specify
the cells and sheets in question. It is hard to see your problem from here.

"drinese18" wrote:

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