Import data from another worksheet

[Burt_100]

Hi,
I have found and modified the below macro to import data from 2x worksheets in the same workbook which is chosen by the user. It works very well but the problem that I have is that I want the new data to be pasted from sheet1 in the user input worksheet to the worksheet named "Service" starting at cell A9 due to headers and the data contained in sheet2 in the user input worksheet to the worksheet named "Maintenance" also starting at cell A9. Can anyone advise how I can modify the macro below to accommodate this?
Thanks
Johnny

Please Login or Register  to view this content.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[Burt_100]

Works perfect, Thanks Jerry