Excel 2007 : Search data. If found, return data and color original cell background

Greetings

I am new to this forum.

I use MS Excel 2007.

I have attached a file called "Test.xlsm"

The 1st tab (Validation and Result), contains a user input area as well as an area where the data is entered, if found.

The 2nd tab (Control Data) contains the data on which the search is done.

Objective:

The user enters an ID No on the 1st tab, presses "Enter".

Program to search data in the 2nd tab, and is found enter the data found (copy) into the column in the 1st tab, adding
each found item after the previously inserted item.

The item found in the 2nd tab must remain and the cell background colour must be changed from default to yellow.

Should the data not be found, message box is required to inform the user that the search was unsuccessful, or
the unsuccessful item can be entered into another column in the 1st tab.

I have tried VBA coding and various formula like VLookup, Match, Find, etc without any success.

I have done VB6 programming, but VBA is totally different.

Thanking You in Anticipation

Julian