I am working on a golf league VB program that looks up each rounds scores and calculates handicaps etc. The name of each worksheet is the date the round is played. The issue I have is that there are rainouts and the pairings for that week are moved to the end of the initially scheduled rounds. In the summary worksheet, I have formulas that reference the worksheet name based upon the original date. There is another worksheet where the pairings are adjusted and the correct dates are associated to the correct round. I can get the correct worksheet name (date) from the pairings table but how can I put this reference into the formula as the worksheet name? Any assistance would be greatly appreciated!