I am using the following macro from Ron de Bruin :
Merge a range from all workbooks in a folder with AutoFilter

I need to change the code to add sheets to the existing active workbook
instead of add a new workbook with a new sheet.
How do I amend the following lines

Add a new workbook with one sheet
Set BaseWks = Workbooks.Add(xlWBATWorksheet).Worksheets(1)


Thanks, xlsops