I am trying to automate a rather arduous process for my company. Dividend rates arrive each day in individual excel files for various funds, and I have to import specific lines from those files into a master workbook.

In order to speed up this process, I created a formula in the master workbook capable of reading the appropriate information on each of the daily files for this month. I would like to expand this formula to accommodate all future months, but I cannot find an easy way to update the the date within the formula.

The formula looks something like this:

=('C:\Users\myname\Desktop\dividend rates\Fund_Name_PRICESHEET_20110804.xls]Price Sheet'!E8)

The part of that formula that is giving me trouble is the date associated with the file (i.e. the 20110804 portion, which depicts 08/04/2011). Is there any way to automatically update that 20110804 number for each month? I really only need to be able to easily change the 08 to an 09, 10, 11, etc. so that I do not need to manually do that every month for each day. As there are a number of funds I want to to create similar formulas for, having to manually update the formula for hundreds of lines each month would take almost as much time as manually inputting the fund information.

Any advice or ideas would be much appreciated.

Thanks,

Rob