Macro required to consolidate info from multiple worksheets

Hi Guys

Need your assitance.

I have a workbook with a number of tabs in it. Some work sheets have the word 'data' in them.

What I am trying to do is create a macro which identifies all the tabs which have the title 'data' in it and then consolidates all the information located on those sheets into one additional sheet called consol.

I am having great difficulty with this.

Thanks in advance
Sasuke.