how to make a selected contents appears automatically according to weeks in a sheet?

hello guys,
i have a sheet named PE which is the main source of handling a contents in other sheet.
would you help me how to make a selected contents in PE sheet appears automatically according to weeks in sheet1?how do i use data validation, offset,or combo box to solve this problem?please show me some alternatives.any help are appreciated...