Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.