Combine Data from all Tabs

Hi All,

I am looking for Macro which will combine the data from all the tabs with the totals to a single sheet. Rows will extend but col remains same. but has to pull all the data from bottom. some time may get a empty line as well.

attached is the sample file.

Thanks,
Sri