Copy Varying sheets to another Summary Sheet

[djlanky50]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I wonder if anyone can help me. I’m not an expert at VBA but can get bye.<o></o>
<o></o>
I have a workbook with my suppliers on separate sheets with the products they supply to us on the sheets (the number of these Products change weekly). <o></o>
I have to put a summary sheet together on a weekly basis from these sheets and have, in the past, gone in to every sheet and copied the product details to the summery sheet. <o></o>
<o></o>
I know there is a way I will be able to pull this information using VBA.<o></o>
<o></o>
I’ve had a go and managed to get the selection copied for each of the sheets but am having troubles telling it to select the bottom of my summary sheet without chopping off the last product.<o></o>
<o></o>
Any help would be greatly appreciated<o></o>
<o></o>
Thank You in Advance<o></o>
<o></o>
Mark<o></o>

 

[Dougie1]

I am not really sure that I fully understand your question.

Are you after some code which will copy and paste all the detail from each of your sheets onto one master sheet ??