Macro to combine multiple worksheets, but there's a hitch

I have nine worksheets that I need to consolidate into one master worksheet. I'd like for the master to automatically update when the individual sheets are updated.

Here's additional detail:

* Each worksheet has the same headers across 20 columns.
* Cells are text only, no numbers.
* Row length varies across all worksheets.
* There are some blank cells.
* There is a worksheet in the file that holds data for drop-downs in the worksheets, so I need to exclude this one from the master.

I've gone round and round trying to figure this out! Any help would be greatly appreciated!

Thank you.

Attach a sample workbook (not a picture or pasted copy). 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.