Hi there,

Columns. Although I'll simplify things a little.
Say I've got 6 solumns from A to F and 5 rows.
I need to begin with row 1 and look in each column of that row.
Open a new workbook by copying a sheet called ("Invoice Sheet").
Rename the new sheet in the new workbook by the value found in that column.
Search the next column in that row and paste the same sheet ("Invoice Sheet") into the new workbook but only if the value (sheet name) is unique and has not been found before.