Build a Worksheet that pulls info from other Worksheets

[HeatherLou1974]

We currently have a spreadsheet that pulls information out of the cells of
other worksheets. VBA was not used to build this spreadsheet and the creator
has long since left the company.
The spreadsheet broke and we can't figure out how to fix it, so I would like
to rebuild it using VBA.
I'm a little rusty and was wondering if someone could walk me through this
or point me to a HOW TO.
Thanks!

 

[HeatherLou1974]

Joel-
Thanks for the tip - and I will try that in the future - but, when I right
click on the different workbook tabs, the copy option was greyed out.
I tried to actually copy the worksheet and paste it into a new workbook.
Here's what happened:
The password box came up (because all of the workbooks are password
protected) for the first two files. I entered the password and the next file
name came up. When the third one came up, it asked for the location of the
file. I pointed to the right file, but then the program was unable to find
ANY of the cells I need it to pull. I *know* that those cells are in there
so I have no idea why it is freaking out.
This is why I just want to build this thing in VBA. It's harder to break
that way.
Thanks!