I have 6 tabs in one worksheet. I create a 7th tab where I consolidate all
the data from the 6 tabs into 1 large worksheet and would like to identify
which tab the data is pulled from. Is there a way to do this?

For example, if the data is pulled from tab A, I want to display the tab
name within the consolidated worksheet. Same for all the other tabs.

Thanks.