Hi,
Is it possible to import data from certain cells in different worksheets within the same closed workbook? If so how would I go about doing it?

Also there are over 100 workbooks, with different names, although the sheets within the workbooks and reference cells would have the same names.
ie. "Bill Sheet" cell F12 would always be the cell I want to take the data from

Thanks