Excel Macro / modify formulas via user input
I have a multi-sheet excel workbook (diff sheet for each day of the month, and a master report sheet). The master report sheet currently consists of links to cells on worksheet '1'.
What I'd like to do is create a macro that takes input from the user via an input prompt and goes through all cells on the master report sheet and modifys the links according to what page the user selects (e.g. 1-31) that they want data from.
I'm a newbie at VBA scripting within Excel.
Any help would be appreciated.