I have a database of different files in one specific folder. All file names are that of my Customers. Each file has muliple sheets. "Sheet 1" may be copied and named different 3 or 4 times. I would like to be able to have a seperate workbook to add a certain cell from each workbook in this folder. If "Sheet 1" has been copied, I need to add those as well. You might as well consider me new to excel. Been with it for many years, but just now trying to get more in depth. For all I know, this may not be a possible thing I am trying to get accomplished.

Thanks in advance.

Stephen

--
Message posted via http://www.officekb.com