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

Sorry Alan,

I need the data to copied from Col B to Col S with the sub totals from all the tab present in file. Attaching a sample for reference

Hi Sri,
Do you mean you want:

a) the "summary" tab to have subtotals? Or
b) do you want the last row of each tab copied to the "summary" tab, which already happens for the "(12)GM Only" tab.
c) both a) and b)

Hi Jeremy.. I need the data to be copied from all tabs and paste it in summary starting from Col B to S. I just need the all tabs data be in a single sheet. Its noting but collating the data from all tabs. Each tab will have the subtotals (Eg tab No. 7 Express Programme) the Col will be same but the rows will change on daily basis.

Let me know if my words are not clear or making sense.

I'm not sure I completely understand but try this and let me know if it does what you want.

Macro Book.xlsm

Hi Jeremy.. Thank you. This is was I was looking for. You code does the same.

Thank you very much

No worries