Data extraction and formatting using macro

Hi Team,

I am not good at macros and need your help desperately. I tried learning but really couldn't succeed in it as the subject is vast and need lot of time.

Here is what I am looking for what macro should do:

To start off macro should pick selected columns such as owners and their projects, start date, price Final price, priority and status columns and paste into new sheet

At the same time only pick selected owners(Dave, Brian, Ken, Russell, Ben)data along with their high low, and medium projects then format the price and the final price column (that is to first convert them to numbers, then change it to the currency format and set the decimal place to 0) and then sort owners (AtoZ) along with Price and final price columns (largest to smallest) into a new workbook and to a new sheet in the same workbook with a name to the sheet called Extracted data

Please note owners may change and new members might get included in the list ( I am not sure if something dynamically can be done about this in the macro)

I have included sample data and how the output should look like....Please help

Thank you,

4gurus