How can I search all the required data say some 'A'from a list of data where
'A' is at some different locations. How can i use Vlookup for this or is
there any other method
I need to get all this data at one place, say suppose i input A again in
another sheet or same sheet 6th column, how can i get all the data of A at
one place
Like in the following example:

A 78 4 6 37 8
B 1 5 6 7 7
C 5 8 9 6 4
A 67 8 8 5 9
B 7 9 9 0 6

I should get something like:

A 78 4 6 37 8 A A 78 4 6 37 8
A 67 8 8 5
9
B 1 5 6 7 7
C 5 8 9 6 4
A 67 8 8 5 9
B 7 9 9 0 6

When I input A I should get teh data present in A that is present in teh
main list in successive rows