dynamic hyperlinking updating

[sonu147]

Hi
I need to write a code that:
1. Scans a particular folder for pdf files.
2. Grab those file names and parse them to extract the necessary info for a unique id column. unique id for "M-ABC752-23-03-11.pdf" is "ABC752" (kind of like unique id = filename - last12 characters- first 2 characters)
3. match the unique id with the rows of the unique id column of excel sheet like abc.xlsm attached to this thread, if match found and the last 8 characters " 23-03-11" give a newer date for the match.....change the date in the column to the newer one and by the existing dynamic hyperlink formula the hyperlink will get updated.
4(a): if it already exists, just update the date cell of the corresponding row
4(b): if the unique id doesnt match any, insert a new row and populate the unique id column and date in the corresponding cells...raise a flag (by probably colouring the row) so that when the excel sheet is opened next people know that there is a new entry and the rest of the info needs to be manually keyed in.
5. the file with the older name remains as an archive in the folder (it would be preferred though that it can be deleted)

Please help asap.