Process improvement help/advice please?

Hi,

A bit new to this but was wondering if anyone could recommend how I can improve something I currently do in Excel (all suggestions welcomed ).

I run a small gas business and every Morning I have to open 83 excel workbooks so that I can check supplier prices. As you can imagine this takes a while! These workbooks all contain different formulas to calculate the price which each supplier will charge me.

I was thinking of making one excel sheet with a dropdown of all the suppliers, which is linked to the individual workbooks, and when I select one it just extracts the sheet with the price and updates the formula so I don’t have to do this same process 83 times. Is this something which can be easily done? I'm a bit clued up on Excel and VBA.

Thanks

Gatti,
It is 83 workbooks, not WORKSHEETS, IMO, you are using a wrong tool. Excel is not designed for data storage, but for data analysis and manipulation. Why can not you buy a simple Accounting software? You have spoiled for choice. You can use VT software which is cheap and can be linked to excel.