Find a word in excel

Hello,

I have set up a spreadsheet to keep track of my daily workouts. The spread sheet is set up as follows:

Column A: Date
Column B: Description of 1st workout
Column C: workout 1 score
Column D: Additional work
Column E: Description of 2nd workout
Column F: workout 2 score

with each month being on a new worksheet.


Each workout can range from 1 to 10 different exercises. I am wanting to write a macro that will enable me to search for all workouts that contain a particular (or combination of) movements. For example if todays workout involved pull ups, box jumps and squats I want to be able to search back through all previous workouts that include squats or all previous workouts that include the combination of both pull ups and squats and have those days entire row copied to new worksheet so i can look over my scores of similar workouts and track my progress.


I would like to search columns B, D & E (in numerous worksheets) for particular words (e.g push up) and have the entire row in which they appear to be copied to a new worksheet.


I have no experience in writing macros and any help would be greatly appreciated.


Thanks, Tim