I need advice on how to go about organizing my data base.
I am in the janitorial business. Over the years I have saved the thousands
of bids I have given businesses. All together I have about 8,000 excel files
which are anywhere from 3 to 5 pages long. What I want to do is take centain
pieces of info from these bids and put them all on one excel file. For
example, I'd like to take the company names, contacts, date, frequency of
service, and bid price from each individual file and then place them all on
one excel doc. Is there a way to do this whithout having to go into each file
manually to extract the desired info.

Any advice would be greatly appriciated