I'll have 7 sheets in this workbook. Each of the first 6 sheets will have a column with 100 values in it (B1-B100). As these six sheets are created, I'd like the column of 100 values from each sheet to automatically write to sheet 7. Sheet 7 then would have 6 columns, each 100 cells long. Place these columns as follows: the column from sheet 1 goes to sheet 7, cells A2-A101; the column from sheet 2 goes to sheet 7, cells B2-B101; the column from sheet 3 goes to sheet 7, cells C2-C101; the column from sheet 4 goes to sheet 7, cells D2-D101; the column from sheet 5 goes to sheet 7, cells E2-E101; and the column from sheet 6 goes to sheet 7, cells E2-E101.
I then will need to take these 6 columns of numbers (100 rows of numbers in all) and filter out any duplicate rows (I only want unique rows of numbers) I think I know how to do this filter, just don't know how to have each of the columns that are built on sheets 1-6 to automatically move to sheet 7 without manually cutting and pasteing.