How do I move data from different sheets?

[darin]

I need some help moving data from different sheets to my front sheet.
know how to move data but I need to throw a twist into copying data.
want to copy data from different sheets and put it under the data fro
the last page. I would also like to put the sheet name after th
data.

Sheet 2
Cell = PVT Smith

Sheet 3
Cell = PVT Jones

Sheet 4
Cell - SGT Able

Example:

1 PVT Smith (Sheet 2)
2 PVT Jones (Sheet 3)
3 SGT Able (Sheet4)
4


Then I can use the counta command and count the data.

Thanks,
Darin

PS - If you want to see the sheet I am working on just send me a note

 

[CLR]

=Sheet2!A1&" (Sheet 2)"
=Sheet3!A3&" (Sheet 3)"

Vaya con Dios,
Chuck, CABGx3

 

[darin]

Thanks. That worked for one cell. I should have mentioned that I wan
to be able to move all the cells (with data) in a column. I will nee
to look at the data in 5 columns on 5 sheets. I need to merge all dat
into one column on my main sheet. Any advice is worth a try.

Thank

 

[CLR]

Darin..........

If I understand you correctly, you wish to scan 5 columns on 5 sheets and
colsolidate all the cells that contain data in those ranges into one column
on your main sheet........I assume one below the other until all is done,
rather than any sort of concatenation to get them all into one column. And,
in doing so, you wish to identify each entry with it's source
sheet........If this is so, I see no way to accomplish this without using a
macro that would be 'way beyond my skill level.........if you don't get a
better answer here from someone else, I'd suggest you might re-post your
request to the "programming" group. Sorry I couldn't be of more help.

Vaya con Dios,
Chuck, CABGx3

 

[darin]

You are right on the ball. I appreciate your help. I will repost it t
the programmers.

Dari