can pull data from the same cell

[charles.j.moses]

Is There away pull data out of more than one spreadsheet when the data is in the same Cell and Have that data all go into the next empty Cell in the same column but in a differentspreadsheett