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?

=RD_Co_A!B5

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