Copy data from all but a few worksheets into a summary sheet based on condition

[d_kjellin]

Hi experts!
Desperate for help as I don't even know where to start on this one..

I have a workbook containing 4 fixed sheets - 'Faktura', 'Oversikt', 'Start' & 'End'. On one of the sheets there is a button letting users create new sheets (via a user form) between the 'Start' and 'End' worksheets. The user-created worksheets will all have a date in cell F6 and two numbers in cells F37 & F40. There will be an ever-growing number of sheets. On the 'Oversikt' sheet in column G (G1 to G12) there are the names of the months.


What I would like to do is this:

- Sum cell F40 on all worksheets except the 4 fixed sheets - based on the condition (date) in cell F6. I need to summarize & "categorize" these by month on the sheet 'Oversikt' in cells G1 to G12. So if there are three sheets with different dates in cell F6 between 'Start' & 'End' - for example Sheet1 has 2012-06-01 in F6, Sheet2 has 2012-06-13 in F6 and Sheet3 has 2013-01-01 in F6 - I want the sum of cell F40 on Sheet1 and Sheet2 to go in cell F6 (G6 holds "June") on the sheet 'Oversikt 'and the sum of cell F40 on Sheet3 to go in cell F1 (G1 holds "January") on the sheet 'Oversikt'.

This macro would preferably update dynamically with the adding and removing of sheets but if thats to complicated then perhaps it could be assigned to a button. Also, each time the macro runs it would need to delete the previous values in cells F1-F12 so as to avoid duplicate values..

Any help would be very much appreciated!

[arlu1201]

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[d_kjellin]

Yeah sure, attachment below.

Fakturera.xlsm

[arlu1201]

Are there chances of sheets which are created between "Start" and "End" to be deleted as well or only added?

[d_kjellin]

There is a possibility that sheets may be deleted yes..