Code to copy data from many worksheets into one summary tab while adding additional cells

[jamesbrown008]

Ok so i am way out of my depth here
I am trying to write a macro copy data from several worksheets into one.
The macro should only cycle through sheets with a "-" in the name
The data is very clean with no headers, totals or blank rows to worry about
What I need is for all rows from all sheets to be copied to one master sheet.
The above part is fairly standard stuff and I could likely work this bit out on my own.
However, here is the catch:
There are two types of sheet:
Agent Conversions and Online Conversions
The naming conventions are as follows
Agent Conversions d-m-yy (technically the date format can be either d-m-yy or dd-mm-yy)
Online Conversions d-m-yy (technically the date format can be either d-m-yy or dd-mm-yy)

What I need is for every row I copy from each worksheet to have the conversion type and the date broken out into two seperate fields on each row.
e.g. if I had a sheet called "Agent Conversions 4-7-11" and the first row had the following values:
Column A: "James" Column B: "47"
The macro would need to create a new row on the Summary tab with the following
Column A: "Agent Conversions" Column B: "4-7-11" (doesn't have to be date format - can be text) Column C: "James" Column D: "47"
It would then of course continue through all rows and all sheets.
If this is something any of you can do I will be forever in your debt.
Thanks
James

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=547142

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.