combining columns from multiple sheets into one column

I have been struggling at this for hours and trying to translate other people's suggestions to similar problems. I just can't get anything to work. I don't know how to use VBN. I'm using Excel 2011 for mac.

I have date on several tabs with Dates (date columns; not the year columns) and cash flows.

date cash flow

I want to combine these all into one column on a separate sheet. If somebody can help me with a formula that would be the best... but if VBN is the only way, please be patient with me and walk me through all the steps to get it to work.

I would really be grateful of any help.

Thank you!

hi

this formula could help

to sum data from the same cell in several sheets, the formula takes this structure:
=sum('Sheet1:Sheet10'!A1)

so to sum all the values in cells C3 in sheets 1 to 8 in your spreadsheet, use the formula:
=SUM('1:8'!C3)

hi lex1
use indirect function.

https://www.dropbox.com/s/64x0c563ks...rkbook5.xlsx?m

check your file.

i m unable to attach file here.

Thank you! That's really helpful. The other thing, that I didn't mention is that it would be great if it could be dynamic. There will be ongoing cash flows that would be added to each separate sheet. I was trying before to use an Index function?

Thanks again!

Lexi