Hi,

Unfortunatly, I am not very well versed in VBA.

Here is what I need to be used within Excel 2007.

** 1 spreadheet has 30 worksheets.

1. I need a macro that will automatically go to the first worksheet,
identify the data and put it into a new worksheet called "FINAL".

2. Then it is to go to the second worksheet and do the same as above,
but place the data in the next A?? cell directly below where the data
stopped from worksheet 1.

3. The same applies to worksheet # 3 all teh way to worksheet # 30.

- Take note that each of the 30 worksheets has it's own name and can
change.
- Take note that some of the 30 worksheets may not contain any data at
all.

I think that's it.

Thanks in adanvce.