Copy worsksheets and paste values only into new worksheet

The following code takes data from several worksheets and mergesthem all into one, however I now need to be able to just paste thevalues. I am now stuck, anyone any idea of how I alter the code todo this?

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

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