merge data from different tabs to one tab

H

Hank

Hi, I need to merge all data to one tab from other tabs in one work file, I
have 20 tabs with all same format columns, I want to copy paste from each tab
to cosolidated tab, how can I do it faster rather than copy and paste from
each tabs??

Thanks a lots.

hank
 
Top