So I have a work book with like 50 tabs and each tab has data in cells O5 through O20 (ex. O5 is company name and O6 is date test was performed and O7 is technician name who performed the test and O8 is result of test etc).
I want a new tab with all the data in rows like O5 becomes A1 and O6 becomes B1 and O7 becomes C1 and O8 becomes D1 etc. Would a macro do this for me? If yes can you give me an example of what code to use?