Thanks to all who answered this post. Using your information plus that in
the posting for indirect reference(again?) I was able to prepare a group of
worksheets (one for each day a cafe was open) each of which was a worksheet
of the day's register activity. I was then able to create a summary
worksheet which has a single line for the pertinant information gathered from
each of the subsequent worksheets. Each daily sheet is tabbed as "May 24",
"May 25", etc. I created two columns on the left of my summary sheet, one
for the month and one for the day of the month. (in columns "A" and "B"). I
then used the following for the cell in the summary sheet: =INDIRECT("'"&
$A10 &" " &$B10 & "'!$D$19")


"Titam" wrote:

I have a text data stored in same cell of different worksheets on the same
file. I need to list them down in a single fresh worksheet. Is there any
formula or any way that I may use?