EXCEL FORMULAS

HI, I'M PRETY NEW TO EXCEL.  I HAVE A COUPLE QUESTION'S.

FIRST: I WILL DO MY BEST TO EXPLAIN....

I HAVE MY FIRST SHEET AS MY TOTAL SHEET, NEXT SHEETS ARE ALL THE SAME WHETHER ITS ONE SHEET OR 999 I'M WORKING WITH, DEPENDS ON THE CUSTOMER AS TO HOW MANY SHEETS I HAVE IN ANY GIVEN WORKBOOK.  ANYWAY, EACH SHEET HAS 2 PAGES OF SAME INFORMATION I HAVE PUT IN TO VARIOUS CELLS, I'N D1 AND T1 I HAVE A NAME, I'N E1 AND U1 I HAVE NUMBER CORESPONDING TO THOSE NAMES.  I WANT MY FIRST SHEET TO LOOK THOSE NAMES UP AND WHATEVER THE NAME IS(21 DIFFERENT NAMES IN ALL) TRANSFER THAT NAME TO THE FIRST PAGE ALONG WITH THE NUMBERS, AND ALSO ADD ALL THOSE NUMBERS UP WHETHER ITS 1 SHEET OR 999 SHEETS, CAN THIS BE DONE?

SECOND:

LIKE I SAID, ALL MY SHEETS ARE THE SAME, BUT WHEN I COPY AND PASTE TO A NEW SHEET TAB, AGAIN WHETHER ITS 1 SHEET OR 999 NEW SHEETS(TABS), HOW DO I GET THE FORMULAS IN SHEET 1 TO LOOK UP ALL THE SHEETS I'VE ADDED?

THANKS IN ADVANCE.