creating a self populating list

[Kfox]

I have data in my workbook broken down into months, but i want to be able to make a weekly schedule and have it autopopulate the information from the other pages.

Another option would be making the schedule on the same sheet but still auto fill from the information above,


Something like if i were to input:
Magic


the cells below would auto-fill with the information from the other sheets in my workbook...


I attached a sample if anyone could offer some advice or help it'd be great, i've tried about everyway i can think of.

Thanks!!