average of cells from user selected range of worksheets

Hi, I am going to give an example the best I can.

I have Sheet1-Sheet10. Cell A10 on all sheets contains a number. I have a seprate worksheet I refer to as "averages" I have a macro like this thus far that works so far:

Please Login or Register  to view this content.

I would like to be able to create an input box or drop down box to select any worksheets at random and only get back the average of those selected. An example would be I would tell excel somehow to look at Sheet2-Sheet7 and give me the average of A10. Next time I would ask for the average from Sheet1-Sheet8. Thanks for looking!

Hi, Have a look at the attached file see if its any good to you.
NB:- Hold down "Ctrl" to select non continuous sheets.
Regards Mick

That works as is. Its part of my solution. The other thing I am looking for is to have the list populate from a seperate workbook and populate the list via the worksheets included in the second workbook. Thanks for helping.

Hi If you mean from the active workbook Fill the "list Box" of sheet names from a second workbook and then find the average of the selected sheets range "A10" from the second sheet. Try this
You will have to alter the second sheet name (shown in the code as test.xls)in the "Userform Initalize" code and the "Command Button" on the Userform.
The second workbook is required to be open for the code to work.
Regards Mick