Macro to insert blank rows so that the total number of rows with data is equal to 1021

Hi there,

I have a total number of 263 sheets in my Excel file. Each sheet has a different number of rows with data. Could anyone please help me create a macro that can insert the blank rows from the top so that the total number of rows (including the blank rows) is equal to 1021.

Many thanks in advance.

Best,

N