GoogleSheets: Copy data from first row to last row

[josephmary]

In my googlesheet file, I have the Main tab (where all data will be consolidated) and 3 other tabs (the data i need to be consolidated)

Is there a script where i can copy the data i need(PER TAB) from first row of the first column until the last row of the last column and pastes on the Main tab?

 

[Cubist]

See if this helps.

7 ways to merge multiple Google sheets into one without copying and pasting

How to make Google Sheets pull data from several documents into one.

www.ablebits.com