I understood from above code that "For Each sh In ActiveWorkbook.Worksheets is the code which selects sheets to be merged.
Please help me modify it to call only for sheets given by me in summary page Column-A, and repeats the sheet entry as many times as mentioned in Column-B of summary page.