I am trying to create a timesheet form that would automatically populate from Sheet name (Calendar) to Sheet name (Timesheet). I keeping track of my time and jobs I work on through Microsoft Office Calendar. I want to export that info at the end of each week and import it into the Timesheet form. I have attached a sample of what I would like do to. Might be to much but I am lost. Tried vlookup, if, and index formulas with desired result.

Thanks for any help

Attached Files

Sample Timesheet.xlsx (23.2 KB, 12 views)