? Index of Names

[terilad]

Hi,

I need some help with a query I have.

I have a range of cells in sheet 1 and Sheet 2 as below

Cell Range A1 to A4
J Bloggs
M Smith
R Scott
G Thomson

What I need to do is list J Bloggs on sheet 3
M Smith in sheet 4
R Scott in sheet 5
G Thomson in sheet 6

so in sheet 3 M Smith will be put into cells A1 and A2 2 inputs as from
sheets 1 and 2 and so on for the rest of the names also.

Can anyone help me with this?

Mant thanks

Mark