Cell Content & Shapes

[pujo]

Hey all.
Just wondering if it were possible to get cell data from multiple cells on different worksheets to show up somehow into one of the autoshapes?

Like a graph/chart, but instead of a chart, I would like to have cell data.
Trying to make some kind of dashboard and the data I use does not require charts nad or graphs.

I know I can click on the shape and in the formula bar type =A1 and that data is there, but I need to be able to have multiple cells, with data from other worksheets within the same workbook.

Is there anything similar to this, or can this be done?

Thanks!!!

 

[mikerickson]

Put something like
=A1 & "," & A2 & "," & B1 in a cell (say Z1)

Then put =Z1 in the shapes formula bar.