How to fetch the file names

Hi guys, here's my query

A folder in win7 contain some files such as 0001.xlsx , 0002.xlsx & this list grows in ascending order everyday.
Now i want the file name that has the 'highest no' to get displayed in my worksheet. For eg if i have files from 0001 to 0058
then i want '0058' to be displayed in my main worksheet so that i don't have to open that folder again & again for reference.

Secondly i would like to get the last/recent 5 file names that i have saved in a particular folder, irrespective of their values.
For instance:

file-a
0001
abc
file-b
address

Kindly please give me some simplified formula. Thanks guys.

Can someone please help with the code?

How much do you know about VBA code? This would require a bit of work, more than I am able to commit to on a free forum. I could provide some guidance as to the approach.

Does first query also requires much of work. i.e. 'fetching file name having the largest no' ?