Excel list to note with status and info flow

I have an excel sheet with a list of information in one page adn in second page I have liek a note that reasd info in first page. first page show list second show like a note where information is linked to list in first page. I want the follwoing feature. I want when I click in the first page on the id or the row to automaticaly upadat the second page with information related to the row in first page. Alternative: I can also write in the refrence(id ) in the second page adn it pulls all info from first page into the second page I prefeer both options. I also want to be able to search on refrences, names etc .. all types of fields I desire. 2) I also want this feature of fetching information from one page to another page to be possible form one document with a page to antother document with a page.. this might require that I must have open both documetn sbut htis is not a problem. 3) I have a page that has parameters. if the start date has passed EX 3 days the text in cell become yellow (ref info in parmaeter sheet) if it passes more days the cell text changes color. 4) status. I wnat to be abel to use a drop down list related to the types of status I have written into sheet 3 for parameters when I choose one of the status the background color of the row change color to the related color in parameters. I have aded a simple example and it is jus to show you concept. You must alsol explain how I link more fields adn pages, documetns togheter for fhurture so I can adapt this to my need. I have basic programing understanding. I expec to make the example takes a few hours for a pro.