Excel: IF ISBLANK Function Seeing 6 Additional Rows as Filled

The project I am working on has several components, so let me start from the beginning. From a calendar program, I am supposed to download a roster of individuals that have signed up for a course and input their names into a Sign-In Sheet. Later, once attendance has been verified, certificates are made for each person who showed up.

I have built a macro that takes the raw data from the calendar and builds the Sign-In Sheet around the list of names, alphabetizes, and formats everything as we need it with a click of a button.

The problem I am running into comes from the certificate portion of the process.

In order to speed up this part, we tried to create a second sheet behind the Sign-In sheet that would pull all the information needed on the Certificates into a separate list that could easily be mail merged into the certificate template.

Three columns in Sheet2 are user specific and change depending on raw data from the calendar. I got these cells to talk to Sheet1 just fine by using the =(Sheet1!A8) function, then copying is down.

However, the other three columns have to be filled from a single cell on Sheet1 that gets typed in after the macro is run (such as the date and location), so it has to be a dynamic link to Sheet1. In addition I need it to look at another range and stop filling in cells on Sheet2 when it encounters a blank cell, so we are not wasting time deleting unneeded information.

I got this working for the most part using =IF(ISBLANK(Sheet1!$A$8:$A$207), "", (Sheet1!$B$2)), but for some reason, the formula is filling 6 extra rows that are actually blank within the A8:A207 range in Sheet1. For example, Sheet1 A8:A207 contains data up to A25, however, Sheet2 is filling in cells as if Sheet1 is filled up to A31.

I have checked these cells for spaces and hidden formulas that could throw off my IF ISBLANK formula, but have not met with any success.

Does anyone have any idea what could be causing these 6 extra cells to fill and what I can do to fix it?

Many Thanks!