Extract data from multiple sheet into one with conditions
I work as a teacher and I have a cumulative timetable with all subjects, a single sheet for each class. So, for each class I have each day of the year with the relative timetable (there are several changes from week to week). I'd like to extract my complete timetable to have it in a single sheet and be able to see quickly where I have a lesson. How can I do it? You can see an example of the file in the attached. Thanks for your help
Data Extraction
So forgive my ignorance in advance as I'm new when it comes to using Excel formulas. I know the basics, but now I'm needing to use more advanced features for my job. Right now I have a column of data which contains medical procedures mixed in with dates. I need to remove all the dates and any other irrelevant info and narrow down my column to just the medical procedure names. The problem is that they are not all formatted the same. Here are some examples and what info I need to extract: 09/19/14 MAMMOGRAM - I just need "Mammogram" 1/13/15 - C-Spine X-Ray - Chava - I just need "C-Spine X-Ray" 2/2/15 - RT WRIST X-RAY - CHAVA - I just need "RT WRIST X-RAY" EGD/Conoloscopy Pathology Report/ 12/11/2013 - I just need "EGD/Conoloscopy Report