I need to copy sheets with similar names to a new workbook. So if there are sheets
Would all copy Range A1:C34 to the new sheet starting at A1 and shifting based on the number of sheets it copies. So the Values of SheetA (1) would be pasted starting at E1 skipping one column.
You could also have just a single sheet
Which would just be copied to a new workbook. Coping range A1:C34 to the new workbook and pasting it to A1.