Not getting the correct cell from another sheet to return

So I have a workbook I am creating to do scheduling at work. The first sheet is the spreadsheet I use to create the schedule and post for my employees, the second is a google friendly formate that now autofills as I create the first sheet, which I then save in csv formate and upload to google calendar for my employees. The third is a daily task worksheet, which has the hours of each employee working that day. I'm trying to get it to automatically pull the time from the first sheet based on the current date and place it in the third.

The formula I have so far is as follows:

=IF(AND(A1>='Store Schedule'!B2, A1<='Store Schedule'!H2),VLOOKUP(TIME(0,0,0),'Store Schedule'!B:H,7,""))

A1 it =TODAY()
'Store Schedule'!B2:H2 is where the dates are in the first sheet
Under the VLOOKUP, number 7 is the row where the time in is

Am I even in the right ballpark so far??? Thanks

No I didn't, I'm pretty new at this. I did try what you suggested but it returned an #ERROR!. What would you suggest instead? I want it to display the actual time from another cell associated the the date in the same column.