Extract rows based on variable position

Hi All,

I have an Excel file that I only want to extract specific rows from. More specifically, I want to be able to extract the rows where column A contains a specific word until column A contains another specific word.

For example,

Col A | Col B | Col C

Name | John | Smith

Country | UK

Occupation | Student

So in the example above, I want to extract the rows from Name to Occupation. However, the position of this row can vary between different Excel files (i.e. in one file, it could be row 20, and in another, could be row 100), and there could be multiple rows in between Name and Occupation.

Is there a way to do this please? Thank you for any help you can provide on this.

Best wishes,

Allan