Copying formula to the next sheet and extend loop

[Vbanoob98]

I have a list of 150 formulas in Column B

I want to put the formula in B1 on the second sheet and extend it from A1:H200

Then I should grab the next formula in B2 and put in on the third sheet

And so on

Any pointers? Thanks for your suggestions, will help me out a lot

 

[Special-K99]

So you have 151 sheets?
Whats the formula in B1 on the first sheet, ie the original formula?
Maybe provide a few examples of the formulas and what you want them to change to.

 

[Vbanoob98]

I have 151 sheets.

Should have said link and not formula sorry. So by formula I meant a link to a cell of a sharepoint excel file.

So the first one would be https//sharepoint.com/file1/cellA1

From that I want it to be copied and extend so I have from A1:G200 in the next sheet and so on

 

[Special-K99]

I dont know anything about Sharepoint so am unable to help with this.