I was wondering is there a way to make multiple sections collapse that are located on another sheet, instead of just one section on the same sheet?

I would like to have a user be able to select the number of items which they will need entries for, 1-25 on Cell D3 of Sheet 1. When the user selects a number then the appropriate number of rows will disappear, only showing the number of rows needed. But I have 1 Table on Sheet 1, 3 Tables on Sheet 2, and 1 Table on Sheet 3, and I need them all to only display they number of rows indicated by the drop down box on the first sheet, cell D3.

Below is a step by step of what I need to happen.

Example:

Rows 10:34 will collapse depending on what is input into cell D3 of the same sheet (“Cover Page”)

Rows 14:38 & Rows 43:67 & Rows 72:96 on Sheet 2 (“WIP Invoices”) will collapse depending on what is input into cell D3 of Sheet 1 (“Cover Page”)

Rows 14:38 on Sheet 3 (“Receipts”) will collapse depending on what is input into cell D3 of Sheet 1 (“Cover Page”)


I am not a great code writer, and I have no idea how to make this work, but I know it is possible. I am using Excel 2007.