I have a workbook with 300 tabs. Each tab contains 2 columns in exactly the same position starting in cell A8 and ending in cell B37 (30 rows). The first column in each tab contains a list of questions and the second column contains responses to those questions consisting of text and numbers. I am trying to create a summary worksheet in the same workbook by having a macro copy the data from the second column in each worksheet and paste the results to the summary worksheet tab BUT transposed horizontally so that there will be 300 rows of data in 30 columns. The first column in each tab should be ignored as it will function as the header row only in the summary worksheet. Any ideas would be greatly appreciated.