lookup help required

[SH0lm3s]

Hello All you wonderfully helpful folk.

I'm trying but not succeeding to get a monthly report summary sheet to work, however the totals will not always be in the same cell reference, however they will be in the same column but different cells. It will always be the total value I need at the bottom. I'm sure years ago I used a sheet that did this but I can't recall how the formula was written. Help very much needed and appreciated 

[#2]

@SH0lm3s 

=SUM(Table1[Qty])

[#3]

Will this work for multiple columns within one area of data? each month we are bringing back more than one data set into the summary from the monthly sheets?

[#4]

@SH0lm3s 

Yes. No. Maybe. Depends on your workbook structure.

Upload your workbook without sensitive data but with sample data.