Hi all,

I have a bit of a challenge on my hands. I am creating a "tool", which extracts and formats various bits of information from a couple of databases. This will enable users to quickly find and copy all the info they need.

The problem I'm having is one of the databases is updated every hour, automatically, and every update is given a different file name (including date and time). Is it possible to create a formula to vlookup in whatever the latest file is?

I am currently stuck at copying the whole new database into a new sheet in my workbook periodically, but this is liable to create issues if it isn't done often enough.

Thanks in advance.