Combining Text

[windpowerfinance]

Hi, I have 10 tabs that are identical. Each tab has written text in columns a, b, c, d, e. Each tab has a different number of rows of information and the numbers of rows in each changes each time I update a tab.

I would like to create a summary tab that will show all the information written in tab 1, and then go to tab 2 and so on. I need the summary tab to catch all the information when the tabs are updated.

Any suggestions? I realize you can not use the consolidation tab for text.

Thanks!

[excel in Excel]

you can try using indirect to pull information from different tabs. If the number of rows is going to change, you probably want some kind of lookup that will get you the number of rows and which rows.

------------------
Jon
http://www.excelinexcel.com

[royUK]

Best approach is not to use multiple tabs,but have one tab that holds all the data but has a column that acts as an identifier. Then depending on the data you can use various methods toanalyseit