Is this a use for Pivot Tables?

[tpedry]

I am trying to lookup a certain value that matches in Column A from a table on one worksheet, have a list to chose from and then place the selected item (and row) into another sheet.

Example

Blue Mantle Estimate WS (worksheet1) Conversion_Work Items to Est (worksheet with table)

Column A5 = 02 Lookup all rows that have "02" in Column A
Show list of all rows that contain "02" in column A
Make selection from list and add selected row to
row 5 in worksheet

I am not sure if I need to have a table on the Blue Mantle Estimate WS that would show the list or what. I now this is probably is very easy.

I am using a Mac if that makes any difference.

I have also included my workbook.
I am also wondering if a Pivot Table is what I am looking for in this case and if so, how would I go about getting the data out of the pivot table results onto the Blue Mantle Estimate WS



Thank you.

Tim