Current Excel spreadsheet need to add VBA capability to analyze and plot historical values

I designed an Excel workbook that includes sheets with the following: 1) one sheet with 400+ names and dates of birth, 2) one sheet that calculates and plots Biorhythm data for each name. The biorhythm data formula is already included. Right now If I choose a name from the list, the formula calculates how many days since birth the person has lived. It also calculates 4 different bio-rhythmic data fields: Physical, Intellectual, Emotional and "Mojo" (mojo is the average of all three). I am also plotting a graph for easier visual of the data. What I need now is to have a sheet where I can query this information and give me a list of all individuals for TODAY whose PHYSICAL or INTELLECTUAL or EMOTIONAL or MOJO or any combination...reaches a range. For example: "Show me a list of people from the main list whose Physical AND Intellectual is higher than .50" I need to take it a step further. 1) I want to be able to query this list for different dates for example: Today, Yesterday, Tomorrow or any given date. 2) I want to be able to query: For any chosen name in the list, give me a list of dates within a RANGE of dates where this person meets a given Criteria. For example: "For John Doe, I want to get a list of dates between April 1, 2016 and May 4, 2016 where His Physical or Emotional or Intellectual or "Mojo" or any combination, reaches above .50 This is a very simple project for the right person.