I have a large table of data from which I would like to extract a number of
sub-tables to new worksheets, for instance I would like to have a sheet
showing all entries for a particular module reference. I suppose this is
similar to an advanced filter but using different worksheets. I would also
like the system to be dynamic. If anybody could help me it would be much
appreciated.