I need a VBA script which will combine multiple worksheets into one. Each worksheet will have the same number of columns, A through N.
Each worksheet has first 7 lines/rows as headers which need not be copied over and over for the compiled sheet. Worksheets can have anywhere from 1 to 4000...