HI

I have been asked to set up a function that automatically combines three separate worksheets into a another single worksheet , ordinarily I would copy and paste the required fields into the other workseet but my recipeints require this to be an automatic function.

Each of the three wokshhets only need fields A to L to be copied into the other workheet in the same workbook. The workseet will need the information to overwrite every time it is used. Also the info to be copied cotains formulae but I only need th values in the cells to be copied over.

Is there a formulae that can do this?

Thanks