Need to Auto Format Sheet based on available data on table

I have created a sheet that tracks performance of individual shops and the performance of the employees. The challenge is that the employee names change as turnover happens. To avoid having to constantly add and delete lines in the master list, is there a way to auto format the sheet depending on the values found? The shop names are all in column A, and the employee names are listed after the store in column B.

Table listed on tab "Shop" as:
Shop1
Name1
Name2
Name3
Shop2
Name4
Name5

Output sheet needs to auto adapt if the data from "Shop" changed to:

Shop1
Name1
Name2
Name3
Name6
Shop2
Name4
Name7

Almost looking for anything listed under shop 1, until shop2 is listed.

Ideas?

Upload an example Excel file (no pics, please) of what you are working with. Be sure to 'sanitize' the data.

Attached an example worksheet. The lines highlighted on the data tab would represent the new data loaded for the next day, with the name changes listed.

See the attached.

I did 4 things.

I eliminated the merged cells in 'shop'. These almost always cause headaches when writing formula. It's best to use them for "Final Presentation" as window dressing....not at data entry points.

I created a 2D Dynamic Named Range in Name Manager. The formula is:

Formula:

Please Login or Register  to view this content.

You can view / edit it in Name Manager by going to Formulas / Name Manager. This DNR is defined to stop at row 50. If that is not enough rows change the row references in Name Manager (the DNR is named NameFinder) to an amount a hundred rows or so more than you might reasonably expect to need.

This allows you to enter this formula in A2:B50 or however far down you wish to go.

Formula:

Please Login or Register  to view this content.

That will transfer the new data from 'shop'.

To cover the formatting in Format Manager I put a formula that formats as you see in Sheet 1. The formula is

Formula:

Please Login or Register  to view this content.

Worked perfect! Thank you!

Your welcome. Glad it worked.