I am new to VBA and have searched widely for an easy answer to this.
Whilst I have found many elements to solve this, I don't have the
skills to pull it all together. I have studied Ron DeBruins material
with some success.
Here is the problem.....

Each month, I have over 40 workbooks, each with 1 worksheet only (with
different names) in a folder (for that month) on a network. Staff
enter data in columns A to BI. The data is totalled in BJ1:BR35 in
every workbook (these cells are sheet password protected). I would
like a macro to run to:
1. Be able to select the folder and files within it (I am OK with
this part)
2. Consolidate all the workbooks in the selected files for the totals
(ie. sum all the values in BJ1:BJ35 - columns BJ and BP and the
first two rows have text - all other cells have values which need to
be summed) and paste values to a new workbook.
Any help is appreciated.

Thank you
Bob