Receiving data from a worksheet, based on a cells value.

Hello everyone!
I'm new to these forums and also new to typing on a tablet, so I would like to apologize ahead of time for any spelling errors.

My issue is that I would like to receive a value from a particular cell in a separate worksheet (Specifically cell A4)
The problem is that I would like to be able to receive this data from different worksheets, based on a cell's value.

Example:
The sheets are "Dynamically" named i.e. sheet1,sheet2,sheet3 etc
In my main sheet, I will be changing the value of cell A1, and I want to use that value to look in a worksheet.
I.E. if cell A1 of the main sheet = 1 then I want to look in sheet1, but if cell A1 in my main sheet = 2, then I want to look in sheet2

So my question to you all, is:
1- Is it possible
2- If so, how??
3- Do I need more info?(I can upload a video)

I appreciate the help
-RoboNerd

Use this formula:

=INDIRECT("'Sheet"&A1&"'!A4")

Hope this helps.

Pete