Thank you for replying and sorry my question is unclear.
In sheet 2 the list is fixed at 60 numbers in column B, starting at row 3. So cell B3 contains 1, B4 =2 and so on.
You have helped higghlight something I would like to create in this appliaction when you mention the situation where the variable in Sheet 1 changes.
OK lets look at the bigger picture..
There could be dozens of sheets (and I would need to create a new sheet and name each one specifically based on a reference text in another cell which is created via a user form). However there would be only one sheet 2 which would have the name 'ways' and in that sheet starting at cell B3 would exist the numbers from 1 to 60.
I have a user form as I said and within that form I have a button when pressed which should create a new sheet, the user would then input a name for the sheet such as 'DB1''.
The sheet would be a copy of a blank sheet stored in the file as the template.
The template (which in this case I have refereed to as Sheet 1) contains the prepared input cells.
One of these cells, B10 is the input cell for referencing our Sheet 2 or ;Ways'. So when the user reaches this cell on the user form they input a number between 1 and 60. Lets say that number is 20 again.
This reference then asks for the first 20 numbers from Sheet 2 'Ways' to be copied and pasted into the new sheet 1 'DB1' starting at cell B13 in 'Sheet 1' so to speak..
Each new instance oof the created sheet could have different numbers of rows required from sheet 2 and each sheet should be permanent but edoitable so if someone changes thie mind about the number of rows in sheet 1 they could change them, usually by reducing or increasing the number of rows by changing B10 again. However a message should appear if there is data entered in adjacent rows on that sheet.
Please note that there are other lists to copy into Sheet 1 instead of those fron cells B3 down on Sheet 2 which are not strictly numerical as they contain letters as well.
I presented my problem this way to get the basics right first before moving on.
I hope this explanation helps to clarify the initial problem. OMG I may have created a monster here. Would it be easier if I sent you the workbook?