I am trying to create a workbookB and the tab names in the workbookB should be coming from the names listed in the column of a workbookA. Also, All the tabs must have a similar template that is coming from the tab of a WorkbookC. Below Macro helps me in getting the tabs from a column but I would like all these tabs on a separate workbook. Any help will be appreciated Thanks.
Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets("Forms").Range("A2"
Set MyRange = Range(MyRange, MyRange.End(xlDown))
For Each MyCell In MyRange
) 'creates a new worksheet
Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet