I am trying to automate a report, in order to do that, I need to import data that appears in the Column A of all the worksheets whose name begins with "R" from a workbook called "PR"

All the data should appear in column A of sheet1 of a new workbook called "Import"

Please advise/share the process that I need to follow in order to achieve the desired functionality.