Excel Dynamic USELIST with data validation

I have a document, spreadsheet, I have altered so that I can do more selection instead of actually having to type data into. What I need to do is have a list "Eq Number", $AA$3:$AP$4, populate based on the item selected in "AREA", $F$3:$Q$4, these are on the "Data Entry" sheet and the items to select from are on the

I am attempting to do this based on the information listed at

http://www.contextures.com/xlDataVal15.html

If anyone can assist me, it will be greatly appreciated and I though I would appreciate it just getting fixed what I would appreciate even more is for the information telling me what I am doing wrong and or missing.

Also feel free to look over the file and if you where I can make improvements to the Data, (the structure has to stay as is since this is a document already in use, I am just trying to create it with less typing since time is crucial and the less time spent doing paperwork the better for us guys on the floor.

When it has been completed I will lock it so that only the areas that need input are the only ones that are being utilized and the document and structure cannot be changed by the end user.

Also feel free to check out the "Repair Time Tracking Chart" and see if anyone can assist me with making the boxes fill in better and more fluently!

If interested let me know and I can send you the document!

Heck I am just going to attach the document and thank you to all who can assist me!

I am using Excel 2007 / 2010

Thank you in advance