Andrew, welcome to ExcelFox.

The first one is rather straight forward

Just add something like
Code:
.InitialFileName = "C:\"
within the
Code:
With Application.FileDialog(4).... End With
construct

For the second one, so from K7, do you mean to add the names of the files that have been consolidated? which then leads to another question, if you start a new consolidation, all data from K7 to below will be cleared and started afresh...?