A workbook with 3 sheets (at the start) contains a macro that gives the user the opportunity to select several csv-files and import them to new sheets in the workbook. This will result in a workbook with (at least) 4 sheets up to the limit of excel.

The newly added sheets have a predifined name: 130927103357-M (date and time -M or -S).
On the second sheet (named "Data") I would like to have the result of severall calculations (min, max, average).

At the moment I'm using the following code witch only works when there are 3 sheets with data:
Please Login or Register  to view this content.
I don't want to create many macro's for "each" possible number of sheets...

I know I could work with adding a formula in each cell first and rewrite it as value:
Formula: copy to clipboard 
Please Login or Register  to view this content.

But this will slow things down so I'm looking for a method to catch this in the first code.

I've tried several array combinations and also tried modified code I've found at tushar-mehta.com.
Please Login or Register  to view this content.
But that didn't do the trick eighter. I hope some of you can solve this issue.