Instructions:

Related posts:

Change chart data range using a drop down list (vba)

Open excel files in a folder (vba)

Excel recursive udf: List files in a folder and subfolders

Insert hyperlinks to all files in current folder