I have a couple hundred worksheets that I need to copy 4 cells of information moved into one list with the Sheet name. They are in a square pattern, plus there is information in the columns and rows after them. Does anyone have a macro that I could use? I don't want to type it by hand and don't have the time to write one. Anyonehave one I could use?
Thank you in advance!