The only change you’ll make is with regard to the workbook and sheet names, so for this article we’ll assume you’re combining data from within the same workbook.
In addition to creating a workbook template, you can add a worksheet based on a worksheet template to your workbook by using the Insert dialog box.
The Spreadsheet Solutions tab contains a set of useful templates for a variety of financial and personal tasks.
For example, you might have established a design for your monthly sales-tracking workbook.
When you have settled on a design for your workbooks, you can save one of the workbooks as a template for similar workbooks you will create in the future.
If you want to create a worksheet template, as opposed to a workbook template, delete all but one worksheet from your file and save it as a template.