Display multiple tabs in current worksheet

M

MLK

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
renaming tabs to fit formulas 0
Extracting tab names 5
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Referring to a cell by using another cell for the row number 6
Embed the same Excel multiple times 0
How to paste the same cell one tab over 1
Variable to rename a tab in a worksheet via VBA 5

Top