I am trying to figure out a way that a sheet can be copied from a
closed workbook into an open workbook. The sheet will have a unique
name which will not be a duplicate to any of the sheets in the
currently open book. I can't seem to find anything on this.