Mail merge from excel to excel???

Hello Excel Gurus.

I have used this site a number of times on things regarding formulas that I thought were impossible and every time someone figures it out. It's been amazing.

This time, I have a question regarding using mail merge to fill in certain spots on a golf scorecard I created in Excel. I currently have 72 scorecards built out on one Excel spreadsheet and I have a separate spreadsheet that I use to pull information from for adding the tee location, the four names of the golfers, their initials, and their handicaps. It's been working for years but here is my issue. This year, I have two new course that were added to the event and now I have to go in and change all 72 scorecards for each of the two new courses. Not only that, there is a new game that we are adding to the round and now I have to change the format of the scorecard, as well. If I only ever had to change one scorecard when big changes like this had to be done, it would save a tremendous amount of time. Having the option to merge in the information that needed to change on each and every scorecard and to print them out automatically like envelopes would be awesome.

I found the attached VBA code but now my issue is I don't know how to fill it in with the proper cell information.

Can someone please help me with this? I appreciate any help.

Thanks and have a great week,

Mike