The space in the name is possibly the issue.

Try writing a SQL query to your Excel file instead of just selecting the sheet name in the dropdown list.

There you can put the sheet name in brackets, what will solve the issue:

[POS Report-XXXX BRANDS-YYYYYYY$]