Macro needed to create summary page

[acphogg]

Hi all, I have an xls with many different worksheets in it and I want to pull certain rows from each worksheet onto a summary page. Essentially each worksheet is the same format and contains company prospects split by industry, however I only want to pull the active prospects (marked by an A in column A of each sheet) onto the summary sheet. I suspect that the best way of doing this is to create a macro to create that summary page by going though each of the industry pages and pulling each relevant row onto the summary page. Can anyone help? Thanks

 

[mdeshazo]

Years ago I used the code from this post by Bill.

http://www.mrexcel.com/articles/table-of-contents-macro.php

It is likely adaptible to your needs.

Cheers,
Michael D

 

[acphogg]

Thanks, but not sure that will do the trick as I want to pull quite a lot of data onto the summary page.

Any other ideas much appreciated!

Thanks