Hi,

I have a workbook that has 21 sheets in it.

The first sheet calls for information from the other 20 sheets and collates it in a table that is ranged D9:W28.

Currently the information displays under the column relating to the sheet it was called from, so all Col D looks at sheet 1, E Sheet 2, F Sheet 3, etc... If the sheet does not have information, the table shows a blank cell (but it's not really blank as it has the formula for that sheet in it).

Is there a way of having the information in the table moved to the left of the row it's on (to the first visually blank cell in the row), without ruining the formulas.

So for example, if Row 9 columns D, E & W had information on them, it would move the information in W to F, as F is the first visually blank cell.

Hope this is clear enough to understand.

Appreciate your help.