Need to create worksheet based on data in another worksheet

[landman08]

I need to create an ownership report that reports data from another worksheet. The first thing that needs to happen is that the macro needs to ask which worksheet to read from, then it needs to ask which worksheet to place the data into. Once that is established, the macro would read the worksheet from which the data is recorded from. It would read data on row 9 starting in column G through cell CE9. When the number is greater than 0 it would insert the name found below the number in row 11 into the ownership worksheet. It would also insert the fraction found in row 3 in the same column as the number and name onto the ownership worksheet. So on the ownership it would display the name from row 11, number from row 3, number from row 9, each within a separate cell (but on the same row). The other issue is that it needs to delete the data on the ownership report when the macro is run again because the ownership is continually changing. I hope this makes sense. Sorry it so long and wordy. I am brand new to VBA so please be very specific in the instructions. Thank you for your time!