Combining several workseets into a single worksheet

[Dragon 71]

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.

I believe that this would be done using a Macro but I have not used macros before so would not know how to write this
coulld you advise please

Many thanks

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-...leds-multiple-workseets-single-worksheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).