Ahhh file name is consistant for each consultant, so the source file name method would work a treat! (Great idea!)

Source columns are K and O on consultant tracker, the formulas in the background produce a figure in those columns, this would be the were the data would be pulled from. If possible, for both Fee (top section) and Commission clients (2nd section).

So for Fee sections I'd say include Rows 3 to 6 (I can expand the fee section on each tab to account for this, as they are only set at 5 currently). Then for the commission section, this would be row 11 to 45, I can edit any of the sheets that arew currently not at this number of rows to match.