I have many files created from a template for construction estimates and invoices. I want to make a excel file that would populate a list from all these saved work books. Example each saved file has their "Name" from cell B2, the "Date" from cell E1 and "job #" cell E2 . Headings would be something like FIle Name | Customer | Date | job. If I could make a master list that would update when new files are created.
Not sure if this is possible or I explained it right.
Not sure if this is possible or I explained it right.