copy data to new worksheet

I need your help please.

I have a spreadsheet with 3 workseets in it in my spreadsheet. I want to create a 4th worksheet and use the data, excluding the labels and dates. BUT, everyday I input new data for the new day and I would like to have it automatically replace the data fields in my 4th worksheet.

Worksheet Name #1: Orders
Date Monday Tuesday Wednesday Thursday Friday
8/8/08 102 382 231 232 243
8/9/08

Worksheet Name #2: Custom Orders
Date Sep Oct Nov Dec Jan
8/8/08 523 233 812 233 442
8/9/08

Worksheet Name #3: Increased
Date Red Yellow Green Orange White
8/8/08 3.03 0.03 0.398 24 2
8/9/08

Worksheet Name #4: Totals

Monday =
Tuesday =
Wednesday =
Thursday =
Friday =
Sep =
Oct =
Nov =
Dec =
Jan =
Red =
Yellow =
Green =
Orange =
White =

Originally Posted by pentrix2

can anybdy help me please?

Hi,
Supply a sample workbook.....showing the original layout and then the desired layout.

Try index match,
Here is your example back, look at the changes I made.First sheet had date and time,changed it to date only.data in reports did not match the headings in the other sheets, your example showed a different date than what the results would have been.