<div>
That was amazing. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Lets say I have a MASTER worksheet and 10 other sheets of the same data. &nbsp;Im looking for a quick and easy VB code to clear out the MASTER sheet and append all the data from the 10 sheets into the MASTER sheet. &nbsp;What is the best way to do this? &nbsp;The real trouble Im having is dynamically appending the sheets. &nbsp;I want to code to account for additional sheets that I may add in the future. &nbsp;Something like....DO Until Next Sheet is Null.
</div>
</div>


Lets say I have a MASTER worksheet and 10 other sheets of the same data.  Im looking for a quick and easy VB code to clear out the MASTER sheet and append all the data from the 10 sheets into the MASTER sheet.  What is the best way to do this?  The real trouble Im having is dynamically appending the sheets.  I want to code to account for additional sheets that I may add in the future.  Something like....DO Until Next Sheet is Null.

Appending data from multiple sheets

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