I have a number of workbooks with a sheet called "EST". These workbooks will
all be stored in the same folder, and are named "052-336558", etc) all
numbers. Cell B2 in each sheet has the same number as the file number.
Several cells on these sheets need to be captured in a Summary. Cells are
same reference on each sheet (ie Field Hours, Shop Hours, Cost, Etc.)
I want the summary sheet to have a column reference that goes and looks for
the file number and than grabs my data from those external sources. Any
suggestions?
Bookmarks