Dropdown box in dashboard to sort and pull certain cell data from another worksheet

Hi all,

I have gone through the forum items looking for something similar to my situation to no avail. Hoping someone can assist with my latest issue.

I have a Project Workbook with the first page being a dashboard. Within the Dashboard I would like to highlight jobs for the current week.

I want to select a date from a drop down in the dasboard which will list "Week Of". I want it to look for jobs scheduled for that week in sheet 2 Column I and pull certain data from that row, such as Column A, Column B, Column C, Column D, Column F, Column J and Column L.

Is this possible?

Thanks in advance
juni

I have attached the spreadsheet I am currently working with

I used the following formula:

=IF(ROWS(D$12:D12)>$H$9,"",INDEX(Sheet1!B$2:B$60,SMALL(IF(Table1[Scheduled W/O]=$G$9,ROW(Table1[Scheduled W/O])-ROW(Sheet1!$B$2)+1),ROWS(D$12:D12))))

The only issue I have now, is the macro which I have on Info to cut and move closed items. Returns a REF error on the Dashboard.