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

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