Merging template changes into spreadsheets

Hi, I'm new to this forum (and to Excel in general) and this question may have already been asked and answered but I don't think so. I have a template and several spreadsheets based on this template, and when changes are made to the template they need to be manually merged into each spreadsheet, a very painstaking, time consuming, and error prone process. Changes are mostly added rows, data tables, and macro (coding) changes. Surely there must be a better way of doing this. There must be some way of automating at least part of this process, or so I would think. I know that changes to a workbook can be tracked, but I don't shows changes to code, and I don't know if it is true for templates as well (but I suspect that it is); at least this would show me what changes to the template had been made, but maybe not changes to the code, but this is only a small part of the problem. Any help would be greatly appreciated.

Anybody? I have not found any workable solutions so far. The spreadsheet comparison utilities that I have tried so far have all failed miserably (and for business reasons I can't use a web-based utility). I think the code portion is fairly simple in that I can simply copy all code from the new template into the workbooks, but even this doesn't appear to be simple (remember I'm a newbie).

Any help that anybody can provbide would be greatly appreciated.