Auto data separation

Hi Roy

Thanks for your suggestions. I'm still trying to get it to work with the individual sheets - I will probably need to be able to read out of the workbook from other workbooks. I can do it all via a horrible macro using <sort>, etc. but it's not pretty....