>No Sorry, not an option, I still have to get the original data  from
elsewhere. There are approx. 25 worksheets  which is why I use merge
VBA as below. I now need to take info from one  workbook to this
workbook and then do the merge. Only thing is I do not have time to
give each formula absolute reference.

So now when I use the merge vba it takes reference from the other
workbook but alters all the cell references.