Help with this VBA Code

[superfb]

Hi All,

I have a VBA code that allows me to select various files from different file locations from different years and almost helps to create a timeseries table. However i have the following issue:

a)I would like to implement a list box that allows me to select the years i would like to copy over from a listbox
b)Also sometimes it misses out the years and causes a gap in the data, not sure because there maybe an extra gap in the file name or unknown character that isn't allowing it to be picked up

Create Time Series.xlsm

drive.google.com

i have a copy of the excel sheet stored in the above link if that helps.

Would welcome your thoughts and insight

Thanks

 

[superfb]

Anybody?