Recent DiscussionsNewest TopicsMost LikesSolutionsCOMPILATION OF EXCEL SHEETS FROM A FOLDER I have a lot of Excel files with the same header in one folder. I want to put all the sheets on one sheet. I want to ignore rows 1 to 5 and use row 6 as the header for all the sheets.
