Open dialog box to select desired folder

Dale Anderson

Concatenate all cells in range with an optional separator

Dale Anderson

List all worksheets as a named range using cell ‘A1’.

Dale Anderson