Extracting Data From Multiple Sheets into 1 Sheet

[feliciag]

I'm working with multiple worksheets in one workbook and want to find a way to extract data from the multiple tabs into one sheet. Each tab has different headers, see below. I only want to pull out certain data. Each worksheet would be updated weekly.

TAB 1 HEADERS:

Shoot Date

Air Date

Release Date

PROJECT

STATUS

CHANNEL

STUDIO

IM POINT

CD

WRITER

PM

DIRECTOR

EDITOR

BUDGET

<tbody>
</tbody>

TAB 2 HEADERS:

Air Date

Project

Budget

Shoot Date

STATUS

PROMO TEAM

SCHEDULE

CREATIVE

ISCI

<tbody>
</tbody>

TAB 3 HEADERS:

Air Date

Project

Budget

Shoot Date

STATUS

PROMO TEAM

SCHEDULE

CREATIVE

ISCI

<tbody>
</tbody>

TAB 4 HEADERS:

Air Date

Project

Budget

Shoot Date

STATUS <tbody> </tbody>

PROMO TEAM

PRODUCTION

SCHEDULE

CREATIVE

ISCI

<tbody>
</tbody>

I only want the below info in the new sheet.
NEW SHEET HEADERS:

PROJECT

NETWORK

PROMO TEAM

AIR DATE

SHOOT DATE

IM CONTACT

STATUS

CREATIVE

<tbody>
</tbody>

I have excel 2016. I'm working off of a mac. I don't seem to have Power Query and am restricted from downloading in my office.

Please let me know if you need more info.
Thank you,
Felicia

 

[pbornemeier]

Is the PROJECT value the common link between the four tabs?
Most of the elements you want to include in the new sheet can be taken from more than one input tab. What is order of precedence for data that differs between tabs?
Is Network Channel or Studio? (don't know)
Does IM Contace = IM Point (probably)

The table below looks odd, but when pasted into a workbooks straightens out.
NEW SHEET: PROJECT NETWORK PROMO TEAM AIR DATE SHOOT DATE IM CONTACT STATUS CREATIVE
TAB 1 HEADERS: PROJECT "CHANNEL ??
STUDIO ??" Air Date Shoot Date IM POINT ?? STATUS
TAB 2 HEADERS: Project PROMO TEAM Air Date Shoot Date STATUS CREATIVE
TAB 3 HEADERS: Project PROMO TEAM Air Date Shoot Date STATUS CREATIVE
TAB 4 HEADERS: Project PROMO TEAM Air Date Shoot Date STATUS CREATIVE