Macro to pull selected rows from multiple sheets to a summary sheet

[Hanford]

I'm definitely not a programmer and would rate my Excel skills as average at best.

That said, I'm looking for help creating a macro to pulled selected rows from multiple worksheets and paste them all in a summary worksheet. For example, if column A has "Strategy" or "Distribution" in it, I want to pull that into Sheet 5. I want to do this for Sheets 1-3.

I want columns A - H to be pulled into the summary sheet only. The number of rows on sheets 1-3 will vary and continue to grow.

Anything anyone can do to help would be greatly appreciated.

Thanks!

 

[spootnic]

Hello.
I am trying to achieve something similar using a macro. However, my workbook may contain up to 50 worksheets. What I would like to do is copy the second row only from these 50 worksheet into a separate sheet (the summary sheet). Can you help please?