Can I get some advice on setting up financial reports using Microsoft Word and Excel?

I have set up a financial report in Microsoft Word and I have imported files from Excel into the report. Now, I need to set this same report up for several clients using the same Excel documents, but with different data. Then I need to set each one up for different years.





My thought on this is to set up a folder for each and copy and paste the original documents into each folder. Then change the names of each document, both Word and Excel, and change the links in the Word to link to the correct Excel file.





I need to keep the two files together in case there are any changes. Our auditor will be using these files so I am trying to set them up in a way he can easily access them.





Is there any easy way to do this? Am I on the right track here or am I making it more complicated? Any advice would be appricated!!!Can I get some advice on setting up financial reports using Microsoft Word and Excel?
I think an easier solution would be to ditch the Excel spreadsheet, and create an Access database for the report data. Then you can design 4 different reports for the 4 different years, and all the data will be in one place. Also, if more than one person needs to access the data, they can if it's in a database. E-mail me if you have any questions or need more details. Good luck!