creating individual databases from smaller ones

Hey everyone, I posted in the other forum and just wanted to link it in here too to see if anyone has any wisdom they could share with me. The question/situation is explaining in the first post on the link.

thank you very much!

http://www.excelforum.com/excel-gene...51#post2854751

**I would like to add also that I will be making this workbook but it will be someone else who will be using it in the future. I will not be present so, ideally, whatever function I end up using can be easily repeated by someone without the same expertise.