In this example, I want to copy the “Forecast sheet”, which I can do using this standard Excel function. However, I want to copy this worksheet multiple times simultaneously.

Hence, we will need to use a macro to achieve this.

This video will show you how to copy a worksheet multiple times in a workbook.

Download Spreadsheet Vault SpreadsheetVault – Excel Copy Sheet Multiple Times (solution).xlsb