Look up a cell links to woksheet in another workbook

[t16732]

I need to find data in another workbook that has many tabs (worksheet)in day for the month, the worksheet that I require the data into has a reference to the tab such as Day1.I need to, each day retrieve data from a cell (same cell)on different tabs (Daily / Month) and place it in the column under that day on the worksheet.

How do I tell the cell lookup for the day on tabs in that workbook and find cell A1 and copy to this workbook

thanks in advance
Ron

Has anyone got an idea how to do, do you need more info?