Macro to create a Summary Sheet matching the Titles

Hello All,

I am using Excel 2013 and have many sheets in a Workbook.

I want to create a Summary Sheets matching the Titles in Row 1.

Data will start in Row No 1 and across. Max Title would be till Col W as shown on Sheet1.

First Column will be ITEM and last column will be REMARKS

I want a VBA code to run on all the sheets in the active workbook and create a Summary sheet as shown in the sample attached.

The Summary sheet should show all the Titles as per Sheet1

Blank Cells and 0 should be omitted.
Thanks in advance.

try this:

Please Login or Register  to view this content.

So you don't have all the titles on the "Summary" sheet?
I guess none of the sheets contain all the possible titles?
If not, we have a problem.

So let's say, if sheet 1 has 2 titles, they go to cells C1 and D1; sheet 2 has 3 different titles than sheet 1, they go to cells E1, F1 and G1 (regardless of the order).
And in the last column, in this example, in H1 "REMARKS".

That's right?

Try this:

Please Login or Register  to view this content.

I added a new macro, in the previous post, it creates the summary sheet with all the titles.

Works great only one thing as mentioned in the OP it should not pull up "zeros".
If you could amend your code then it would be perfect.

Sorry for that, I forgot. Try the following:

Please Login or Register  to view this content.

Glad we could help & thanks for the feedback