VBA for copy/paste a tutor perhaps....

First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and that is where it ends. VBA (like powerpoint) is not my forte`.

I am trying to figure out how to copy tab2, cells A8:AU through A?:AU from one sheet to another. (Obviously the A? means that the sheet may contain various rows.) I have to do this for tabs 2 through ? as well.

I understand two things... First I have to locate the data from tab 2 (A8:AU through the "last row") and input it into tab1 (A8:AU through ...) the second is that I need to locate tab3 (A8:AU through another "last row) and append them to tab1 again throughout the process.

If I weren't bald, I would simply pull out my hair. I don't understand how to accomplish this. I have also learned the hard way that once you do something with a macro...it is done.

Is anyone willing to show me what I need to do to accomplish this? Does this even make sense to anyone?

I am not the kind of person to ask for the easy answer... I am the person who knows when to cut sling-load and ask for help.

Any information to help me learn this is greatly appreciated!