Function to extract certain words in file name and have certain cells in Excel update them

Hello,

I need a function to extract certain words in a file name (located in a specific folder) and have certain cells in Excel automatically update themselves according to the files inside the folder.

For example, I have a folder called "Completed Projects".

In this folder I have one file called, "Revision Level (Nil)". In Excel, a cell in should be able to automatically enter the following data "Rev Level 0". Let's just say that this cell is located in Column B. When I add another file with the title "Revision One", the next row of Column B should reflect "Rev Level One" and so on.

Is this possible? If so, what's the name of the function? I tried googling but so far I've only come up with Filelen( ) for checking file size data and not much else.

Thanks in advance.



Brah.