How to get the value of cells from one sheet to antoher

I need to collect data from one sheet into another.
Actually I need data in cells B4-G4 all the way down to
B225-G225. Adn to make things worst I need to do this for 8 different sheets.

Is there a way to get those data without having to write the formula into each and every cell?

Please Login or Register  to view this content.

This is the formula, and of course for next cell the same except B6 all the way to B225. Then I will need to repeat that 221 times for column C and so on.
If I have to do that for all cells it seems like I am in for hard labour.

I hope and pray this can be automated?

As of now I must use this approach. Data in the other sheets can change but the sheet where I use the formula is formatted correct according to my needs so if I solve this i spare alot of repetative work.

Good on ya for finding the solution. Nevertheless, please take the time to mark the thread solved