Help with loading multiple files from userform
 

Hello
I am a building cost estimator
I have a 28 page workbook. My problem is that I am at the maximum formatting
limit. I am going to seperate the 28 pages into single files then from a
userform select any number of the files and form a new workbook and name from
a cell reference. Each of these files are linked to a summary sheet (the
master template) in the newly formed workbook . One file may well be selected
several times therefore I would need to have the facility to rename the
sheet, copy, paste, and insert a section into the summary sheet. For example
I select the framing file three times and these are inserted into the new
workbook and renamed framing1 , 2 & 3. The first file is linked to the
summary page. Because there are three framing sheets I would copy the
framing1 section, down and change the link to link to the framing2 and
likewise for the framing3. How would I write the code for my form to do this?
I'm working with 2003. I have 2007 but it is majorly slow and I'm a vba
novice. Just enough knowledge to be dangerous!!!!
Any help would be much appreciated.

Brian