Help with Pulling Data from Multiple sheets using Indirect Formual.

Afternoon all,

This is like a previous post but it was already solved so looking for an amendment to it to adjust to new demand.

I'm trying to use Indirect to pull data from multiple sheets into one, however i need it to skip the data if there is in the other column.

So for example if Column B is the data to pull, if A4 has a value then it wont pull the data from there and will skip to A5 that has no value and pull the data from B5.

This needs to be continue as the sheets have data from Row 4 to Row 300/350. but only up to 10 data values needing to be pulled.