I have a master list of unique references stored a single column in an Excel spreadsheet held centrally on a server.

I wish to create a macro in a seperate workbook that when I run it, it finds the first available reference (non blank cell) in that column and cuts and pastes it into a cell in my workbook. This reference has now been removed from the master list so that any one else accessing the list cannot use this reference so the master list gets gradually shorter and shorter as references get used and pasted to other workbooks. There will be multiple workbooks accessing this master list so it is important that a reference can only be used once.

Any ideas would be greatfully appreciated! Thanks in advance