Copy data ranges from multiple excel worksheets

Scott - Jan 29, 2016 at 04:49 PM

I have a series of worksheets all with identical formats but different data information. I want to take information in cell ranges e30..k31 and transfer them to a single worksheet with e30 and e31 in the same rows, f30 and f31 in the row below. All the 30 would be in the same column and 31 in the same column.