VBA code amendment query

I'm using the following VBA to retrieve data from a number of workbooks in a folder, and then present it onto a new spreadsheet.

Current VBA code

Please could someone explain how I would tweak it to allow for

• the selection of workbooks to be retrieved from, rather than retrieving from all workbooks (want to update as we go through the touament, rather than having to wait to the end!), and
• (if possible) allowing for rows that have no data in cells A6:A16 and A23:A33 to be skipped (not brought across during import).

Several virtual pints will be bought for anyone who can help!