Can anyone suggest the best way for me to combine 100 worksheets into a master sheet if the information is NOT in the same format in every sheet? I was given all of this information as text and converted it to Excel in order to analyze.
I am trying to combined all 100 sheets into 1 master...