Excel Data Manipulation & Power BI

Hi

I download an Excel workboot and it has a number of sheets in it all in the same format.

In power query I know how to extract the data in rows 6 to 10 and combine the sheets.

The person's name is in cell A2 or the sheet name. The part I don't know is how to create a column containing the person's name using power query.

The desired result being:-

Thanks in advance

PB