I need to paste a selection of data from a larger table on another worksheet,
subject to preset requirements.

I know how to select the required data field, but I don't know if there is a
way to paste this data onto a new worksheet in its sub-table form?