Consolidating Sheets Data

Hi,

I need some help around the following:

I have a file with 3 tabs: sheet 1, sheet 2, sheet3.

I want to consolidated the data of these tabs in a single sheet, along with the tab name. The "consolidated" sheet in the attached file is my desired output that I need.

Will you folks help me accomplish this? Thanks in advance

HI
Paste the following codes in the macro window (alt F11 insert > module)

Please Login or Register  to view this content.

run the macro

Thanks a lot.. it worked for me...