Auto-populate a Sheet from Data on Another Sheet

OBJECTIVE:

+ We have one Master Project Calendar that is an archive of all projects. I would like to have one Excel file that has the Master Calendar on one sheet with a sheet for each Project Lead (as dictated on the Master Calendar sheet) that will auto populate their specific projects.

+ So I would like to be able to edit the Master Project Calendar, but any changes will be automatically reflected on the particular Project Lead’s sheet.

+ I also would like to be able to enter a DUE DATE (Column D) and have Columns E through L be autopopulated with the dates for each week.

So if the DUE DATE (Column D) was 4/1/13 then:

Column E – 2.4.13
Column F – 2.11.13
Column G – 2.18.13
Column H – 2.25.13
Column I – 3.4.13
Column J – 3.11.13
Column K – 3.18.13
Column L – 3.25.13


Can someone assist with the optimal formula, as I’ve tried ones I’ve used in the past but they aren’t working well?Project Tracker EXAMPLE.xls

Well im working on it pls just answer so tomorrow i can send u some thing that can help u

I'm sorry...do you need me to send something to help with an answer?

Fotis1991, thanks so much. The file you attached seems to work until I try to extend the range of data to search on the MASTER sheet...since I will have more than 20 projects on the Master Calendar that the individual employee sheet will need to display.

I used this formula:

=IF(ISERROR(INDEX(MASTER!A$5:A$20000,SMALL(IF(MASTER!$N$5:$N$20000=$A$1,ROW(MASTER!A$5:A$20000)-4),ROW(MASTER!A1)))),"",(INDEX(MASTER!A$5:A$20000,SMALL(IF(MASTER!$N$5:$N$20000=$A$1,ROW(MASTER!A$5:A$2000)-4),ROW(MASTER!A1)))))


What am I forgetting to change?

Oh my gosh...DUHHHHHH! :-)


Thanks so much for all your help!