Copying cells from other worksheets- Combined into 1

[bamaisgreat]

Looking for away to copy a range of cells from 28 different sheets and have them pasted into another range of cells or another worksheet without any blank rows.
This could be a macro but it would be best if it just self populated itself.

As always thanks for all you help.

 

[SpillerBD]

The best method is the newest. If you have Excel 2016, there is a new tool called Get and Transform. Get and Transform was available in 2010 ad 2013 under PowerQuery thru certain versions.

What version Excel do you have?

 

[bamaisgreat]

I use Excel 2016.