Copy Rows

I have very little excel knowledge, well basic rather. Here is what I have.
I have a workbook with a monthly totals sheet and numerous other sheets(tabs) across the bottom that each represent a vehicle. Each vehicle tab in colum A has every day for 3 months going down. ex a1 is 10/1/08 a2 is10/2/08 a3 is 10/3/08 ect...
what I am needing is another sheet or tab that has one day with all vechicles and info for the complete row for each day ex: for sheet labled "MT-1" I want to copy a1:a7 on a new sheet to, let's say d1:d7. Then have another vehicle's same info go to e1:e7 & on & on.
IS this possible? Thanks!

Hi and welcome to the forum.

Perhaps stating the obvious, but can't you directly link your summary sheet cells to the individual car tabs?

e.g. D1: =MT-1!A7

HTH