I have a file in excel with various sheet's, i want to copy the columm H (from all the sheet's) and paste in only one columm in the same file (or another), in a automatic way (macro, formula,....).
How can this be done?????

PS. The columm contains numbers (with formulas), and it's in Excel 97

Thanks
:-D