Hi, I have an excel file with several tabs (tabs A-E) of client data
for each city, plus an additional tab (tab F) with data which I need
to append to these tabs (in tab F, column B stores the city which each
row of data belongs to). The workbook already has a macro that
calculates subtotals for the client data for each city. What would be
the formula to automatically append the data in tab F to below the
respective tabs A-E subtotals?

Thanks!