By using FillAcrossSheets you can copy the Range of one worksheet to other multiple worksheets.
Steps:
- Create an array and assign multiple worksheets names ( in which the data to be copied), as an array elements.
- Copy the range of main worksheet and paste it to the other sheets using FillAcrossSheets.