Multiple Sheets into a Summary

[Dreamwine59]

Hi,
I posted this question once before and didn't attach any documents. I would like a relook at the macro I have written and any advice on better procedures would be appreciated. bascically I am taking information from about 8 spreadsheets and combining them on a summary work sheet. Sometimes the info is in a series of cells, sometimes it is different worksheets and sometimes different workbooks. I am doing this one cell at a time, and wondering if this is the best way.

thanks in Advance

[mrice]

No attachment

[Dreamwine59]

Sorry,
The Excell sheet was too big so I sent the word doc. You will see notes on where I change the cells every month.

[mrice]

It's not clear what you are needing to change each month. Can you give an example of two different months and how they differ?

[Dreamwine59]

above each section of code I have a comment consisiting of the line I am updating and what to add for the next month.
In some cases I amd adding a cell, in some cases I am opening a new monthly spreadsheet, and in some cases I am adding 16 lines becasue the data is vertical on that particular sheet.