|Don't take my response to mean you've wasted my time.|
I simply wanted to reiterate that unless you give us something to work with, it's hard for us to offer specific suggestions that will solve your issue on the first try. The only thing we have to work with is what you post. We can't see your spreadsheet from where we're sitting nor can we read minds.
Let me try this a different way...
If you use the techniques outlined in this tutorial, you'll be able to Single Step through your code and watch as it executes each instruction one by one:
First off, you'll be able to delete the instructions that don't do anything useful, such as the instructions that were recorded by your "clicking back and forth and scrolling whilst using the macro recorder". Each time an instruction does something useless, highlight the line and delete so it won't be there the next time you run the code. That is typically the first thing you'll want to do whenever you want to clean up the bloated code that the recorder produces.
As for your specific question about using the contents of a cell to choose the sheet into which the data will be pasted, let me reword what I said in Response # 1 and tie it together with the Single Stepping technique from the tutorial.
As you Single Step through the code via F8 (Read the tutorial!) I assume that you will eventually come to the instruction where you Select the sheet into which you are doing the paste. It might look something like this where "Sheet2" is the hardcoded name of the sheet (LP1, LP2, etc.)
I sounds to me like instead of using the hardcoded name, you want the code to use the name of a sheet that was chosen from a drop down list. If you replace the line with the hardcoded name with this line, it will use the value in A1 as the sheet name:
In other words, if A1 contains LP1, the code will Select sheet LP1.
Obviously, this assumes that your drop down is in A1 of the ActiveSheet. If not, change the A1 to be the correct cell reference. You may need to use the name of the sheet where the drop down is located in that instruction. If so, it'll look something like this:
This will tell VBA to select the Sheet whose name appears in cell A1 of the Sheet named "Master".
I really, seriously, truly believe that you will gain a much deeper understand of the VBA language if you use the techniques in the tutorial I've written (link above) as you Single Step through your code and watch what each instruction does each time you press F8.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.