Need Help With Referencing Sheet in Function

I am a novice working with Excel. Hopfully you can help me. This is the equation that I'm trying to use but there is something missing.

I am trying to pull information from another sheet in a cell based on the sheet name in A4. A4 is a date code (ie. Jan 01, 2005). I want the formula to be set up to vary based on my A4 cell.

A4=Jan 01, 2005
Worksheet Name= Jan 01
B4=3

Example of code:
='(text(A4,"mmm dd"))'!B4

Thanks for the advice but it didn't work.
=INDIRECT(TEXT(A4,"mmm dd") &"!B4")


Perhaps I need to better explain.

I have a worksheet called: Test chart in which A column has a list of all the worksheet names.

I am trying to pull information from my various worksheets named Jan 01, Jan 02, etc...

I thought using ='(text(A4,"mmm dd"))'!B4 would work but it gives me a #ref error.

I want to read A4 on my Test Chart worksheet to find out what worksheet to reference and pull the value off B4 from the paticular worksheet.

Does this help explain any better?

Success!!!

Thanks for the additional info. With the information you gave me I was able to create the following formula:

=INDIRECT("'" & (TEXT($A4,"mmm dd")) & "'" & "!b4")

Thanks again!!!