Search all workbooks in a specified folder and return the desired cell value and file name

Heah Brendan, code only gave a overall outer border to the table but not a table like look format with each cell bordered.

And serial number is not coming from first row (excluding headers).

Another thing I noticed that, since Sales is number I want it in the format of #,##,###.

Do help.