Excel list to note with status and info flow

IN PROGRESS
Bids
15
Avg Bid (USD)
$8 / hr
Project Budget (USD)
$2 - $8 / hr

Project Description:
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.

Hours of work: Unspecified Project Duration: < 1 week Skills required:
Excel
Additional Files: example.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$35 / hr
Hours: 1 hr/ week
$30 / hr
Hours: 1 hr/ week
$5 / hr
Hours: 6 hr/ week
$6 / hr
Hours: 12 hr/ week
Hire shacoim
$4 / hr
Hours: 5 hr/ week
$4 / hr
Hours: 10 hr/ week
$2 / hr
Hours: 15 hr/ week
Hire habayabah
$5 / hr
Hours: 4 hr/ week
Hire bestblogger305
$4 / hr
Hours: 30 hr/ week
Hire sattagouda7
$5 / hr
Hours: 6 hr/ week