You need a list of all the files to get the data from which probably means
you need a macro. It is probably better to have a macro open each file(s)
from a list of directories and put the data in the new workbook. You
probably also want to obtain additional information like the workbook name
where the data can from.

"KathyJean" wrote:

I want to take the data from one particular cell (i.e., B2) from a multiple
of workbooks and have that data put in a new workbook. I don't want to have
to open each individual file, since there are over 300. Is there a formula
for this?

Thanks,
Kathy