Macro To Copy Specific cells From Multiple Workbooks to Summary Workbook

[Mooseman60]

Hi I am using Excel 2003 and have 27 different workbooks in the same folder in My Documents and would like to know how i can create a Macro to copy cells from all these workbooks to one new summary workbook. All the data is in the same cell numbers in all 27 workbooks.

Eg: The following summary workbook cells to save data too are A3, B3, C3, E3, F3

The cells from the 27 workbooks are E19, L10, L9, L15+L16

So A3 = E19 B3 = L10 C3 = L9 E3 = L17 F3 = L15+L16

I hope this makes sense

 

[Mooseman60]

Hi I am using Excel 2003 and have 27 different workbooks in the same folder in My Documents and would like to know how i can create a Macro to copy cells from all these workbooks to one new summary workbook. All the data is in the same cell numbers in all 27 workbooks.

Eg: The following summary workbook cells to save data too are A3, B3, C3, E3, F3

The cells from the 27 workbooks are E19, L10, L9, L15+L16

So A3 = E19 B3 = L10 C3 = L9 E3 = L17 F3 = L15+L16

I hope this makes sense See attached worksheet

Building	Q1 Total	Q1 GM	Workbook	Q2 Total	Q2 GM
E19	L10	L9	1	L17	L15+L16
E19	L10	L9	2	L17	L15+L16
E19	L10	L9	3	L17	L15+L16
E19	L10	L9	4	L17	L15+L16
E19	L10	L9	5	L17	L15+L16
E19	L10	L9	6	L17	L15+L16
E19	L10	L9	7	L17	L15+L16
E19	L10	L9	8	L17	L15+L16
E19	L10	L9	9	L17	L15+L16
E19	L10	L9	10	L17	L15+L16
E19	L10	L9	11	L17	L15+L16
E19	L10	L9	12	L17	L15+L16
E19	L10	L9	13	L17	L15+L16
E19	L10	L9	14	L17	L15+L16
E19	L10	L9	15	L17	L15+L16
E19	L10	L9	16	L17	L15+L16
E19	L10	L9	17	L17	L15+L16
E19	L10	L9	18	L17	L15+L16
E19	L10	L9	19	L17	L15+L16
E19	L10	L9	20	L17	L15+L16
E19	L10	L9	21	L17	L15+L16
E19	L10	L9	22	L17	L15+L16
E19	L10	L9	23	L17	L15+L16
E19	L10	L9	24	L17	L15+L16
E19	L10	L9	25	L17	L15+L16
E19	L10	L9	26	L17	L15+L16
E19	L10	L9	27	L17	L15+L16

<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>