Make arrary to export multiple sheets to other workbook Hi, I'd like to export multiple sheets to another workbook. I want to make dynamic list for worksheets name , so users can insert sheet name or delete sheet name to export. I want to have this list o

Make arrary to export multiple sheets to other workbook Hi, I'd like to export multiple sheets to another workbook. I want to make dynamic list for worksheets name , so users can insert sheet name or delete sheet name to export. I want to have this list of sheet names in column A in 'SelectSheet' sheet. Then, copy these sheet name and paste in the new workbook. For example, Set v = ThisWorkbook.Sheets(Array("Date","Time", Year") I got above, but I want to decide which sheet I want to export. I want to make dynamic list for this Array and export these sheets in Array.