I need to extract the top three values from in a column and copy the account and value to another sheet.

The table range is not fixed, the account will always be in column A but the value could be in different columns dependent on which day.

The user needs to select a column number then the code will find the top three values and in say column G and copy the value and the account (Column A) to another sheet

I have tried using the large function which gives me values but how would you get the account and value?

Any help greatly appreciated