2k3, Indirect Across Mutlitple Sheets And Cells

I have a sheet that needs to pull data from diferent cells and sheets at the same time. If I have to have all the data on one sheet I can change that as this sheet isn't in production yet.

On Sheet1 cell D6 needs to be able to get data from Sheet2 Cell C2 or Cell N2 or Cell Y2.
On Sheet1 cell F6 needs to be able to get data from Sheet2 Cell C3 or Cell N3 or Cell Y3.

While doing the above it this also needs to be accomplished.

On Sheet1 cell D9 needs to be able to get data from Sheet3 Cell C2 or Cell N2 or Cell Y2.
On Sheet1 cell F9 needs to be able to get data from Sheet3 Cell C3 or Cell N3 or Cell Y3.

Is Indirect able to do this or do I need to use something else? I am trying to do this without macros if possible.