Need to get one column data from long list of tabs in same sheet to one sheet

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)


I have an excel sheet in which on the first tab i have a set of data in which second row has the required attribute which gets matched to the second row in the rest of the tabs.

How to fetch the data from second row in all the tabs to be into the new sheet? And the fetched data should be correspondingly mapped to the second row data in the first sheet ?

Please, provide a feasible resoultion on the same.


Hi Sivaram,

I need an example to help you. Best a link to an image or the link to the Worksheet itself (clean of sensitive data)

Simply the best place to learn Excel VBA