Combining Spreadsheets

I am trying to combine two spread sheets into one. They contain lots of similar information but lots of information is under different titles (and in some cases different formats, Nov-2017 in one, 20/11/2017 in another).

I am aware that excel has a consolidate function but lots of the data in the columns is repeated (Like dates) and I would like to keep it. Also one has a bunch of extra columns that I would also like to be in the new main one. I was going to simply copy and paste the relevant columns but I thought there must be an easier way to do it. I'm not sure if I have explained it well enough

Edit: Attached is a workbook with 2 separate but similar worksheets and the end goal of the combined spreadsheets. However what I want is on a MUCH bigger scale and so simply copy and pasting the information isn't really an option.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.