<div>
I don't think so as your adding sheets it would be difficult or I don't see how without VBA.<br />
If you change your mind and accept VBA then pls provide a sample workbook and it would be no sweat to give you a solution.<br />
gowflow
</div>


I don't think so as your adding sheets it would be difficult or I don't see how without VBA.
If you change your mind and accept VBA then pls provide a sample workbook and it would be no sweat to give you a solution.
gowflow

<div>
I've requested that this question be deleted for the following reason:<br />
<br />
I can't do what I want
</div>


I've requested that this question be deleted for the following reason:

I can't do what I want

BiweeklySummary.xlsx

<div>
That was exactly what I wanted. &nbsp;Thanks
</div>


<div>
<div class="content wysiwyg-content">
I have a payroll workbook that I'm working on. &nbsp;Every two weeks I add another worksheet by copying the template. &nbsp;Is there a way that my total worksheet could be continually updated to reflect the new worksheet, preferably without using a vba.<br />
Thanks
</div>
</div>


I have a payroll workbook that I'm working on.  Every two weeks I add another worksheet by copying the template.  Is there a way that my total worksheet could be continually updated to reflect the new worksheet, preferably without using a vba.
Thanks

Adding multiple workbooks - Dynamic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.