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