VBA Combine multiple sheets onto one sheet for a specific column range and paste as values

Hi I have seen numerous code but am not able to get it to fit my situation.

I have 5 tabs that need to be copied (this could grow so need it to be flexible).
There will be sheets that don't need to be copied so having flexibility to copy data from specific sheets only.
Each tab has +20 columns with different column headers
To bring consistency in the column headers I'm interested in, Columns D-N has been created to pull data from the interested fields and will be the column range I want to consolidate
Consolidate each of the 5 tabs from column D4-N to the last row of data. Ignore all other columns.
Paste data as values (no formulas) to 'Consolidated' Sheet.
Consolidated sheet will start in column D4.

Attached sample data.

Your help is greatly appreciated