Hi,
Happy to know it works.

Now if you rename the worksheets you will also need to change the code to reflect the worksheet names.
Change "Lookup" and "Summary" in the code to your sheet names.