I have several files with multiple worksheets. The first worksheet of each of the files contains up to 5 rows of data (rows 2 through 6) with info that needs consolidated into one worksheet of a separate file. (this new worksheet would then a master from which the data would be sorted several different ways so if there are blank rows copied it would be no issue.)
Last edited: