This is getting the best of me, :(

I have S/S with multi worksheets with system and hardware layout. The
problem is it is all done from left to right. I need to find just the
system and write them top to bottum and which tab they were found on a
new worksheet.

So something like this:
1) create new worksheet called systems.
2) goto first worksheet
3) find first row with system in column A
4) copy rest of row (B-AA) to worksheet systems and paste top to bottom
in Column A
5) go back to first worksheet find next system, if not anymore go to
next worksheet.

Any suggestions?

Thanks,
Ron