Hi,

I would like to create a macro that helps me add values together from different closed workbooks according to the selection in the listbox.

For example,
Let's say I have 1,2,3 as my selection.
Then I would like to go to the add the range A1:A10 in tab "Price" for all 3 workbooks named workbook# respectively.

so if workbook1 has A1=10, A2=5,... and workbook2 has A1=2, A2=3,... and workbook3 are all zeros, then I would like to create a column in a new worksheet using the macro that gives A1=12, A2=8,...

Also I would like to ask how do you pull data from closed workbooks with the names of the workbooks updated every month. For example, this month I would like to get data from MayData.xls, next month I would like JunData.xls.

Thank you very much.