Index match to return a second value from different sheet, same cell number?

[realrookie]

Hello,

Is it possible to have an INDEX MATCH to return a second value that is in the same cell number?

For example: the formula returns the value from A1, Sheet2 but also the value from A1's of Sheet3/4/5...

Regards,
Red

[FDibbins]

If you want to pull in a value based on teh same criteria, but from a different sheet, just change teh sheet name

[realrookie]

Thank you for your reply.

Every time I run my macro to enter data, it moves up 1 cell to the right and adds the new data in place next to the names.
If I had a different solution to my date entries then indeed, changing the sheet name is the solution.

Names are always in column A no matter which sheet (4 of them).
Run macro today:
(Sheet1) Realrookie 16/02/2016
(Sheet2) Realrookie 52013
(Sheet3) Realrookie 258
(Sheet4) Realrookie 987

Run macro tomorrow:
(Sheet1) Realrookie 17/02/2016 16/02/2016
(Sheet2) Realrookie 48593 52013
(Sheet3) Realrookie 369 258
(Sheet4) Realrookie 7852 987

This causes all data related to each other to be in the same cells on all sheets (Sheet1-4, C4 all belong to the same data to the according name)

If it was just 1 person, easy fix and less complicated. But the data is imported with +/-58 names (x5 for 5 days a week)
As I cannot figure a macro out to post the date separately on every sheet, as the date shows up 5 times per name.

I am trying (!!) to make sample sheet to explain what I mean. I know it sounds confusing but it sounds better in my head...

Regards,
Red