Hi All-

I have a workbook ("goals") which populates with YTD info from another ("wrm").

Every month, I duplicate the prior month's worksheet in "wrm," (named for each respective month (i.e. "June," "July," etc.) clear out the prior month's data, (rolling over its YTD info) and the new month numbers are added to it.

Is there a way to have "goals" update to reference a specific cell in the new month's worksheet of the "wrm" workbook rather than retaining the reference to the prior sheet?

This is my current formula which now references July's sheet, but will need to reference August's data at the end of the month.

=SUM('http://SiteDirectory/WRM/MonthlyReports/[wrm.xlsm]July'!$Y$49:$Y$50)

I tried using a macro which performs a search/replace in "goals" for "July" using InputBoxes to enter past and current month names. However, since "wrm" is password protected, it requires me to enter the pwd for each instance.

I hope this makes sense. Please let me know if I'm not explaining adequately.

I appreciate any advice you can offer. Thanks!