Here is the code I am using to import sheets into new workbook.
worksheet Day 5 will change daily. Is there a way to place a value on sheet or have it read tab so it will change daily as I need it to.
Workbooks("Pioneer Natural Resources Trinidad 134 Dickenson 7B 2H Inventory.xlsx").Worksheets("Day 5").Range("A1:K90").Copy
Workbooks("Report Help.xlsm").Worksheets("Inv").Range("A1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Hi,
Yes probably, but if you could supply some sample workbooks including your code and explain how the sheet name will change it would be helpful for us to work out a solution.
Regards
Phil
Here are the 2 Sample files.
The days change along with the tab. Importing it into help file to distribute numbers elsewhere accordingly on daily basis
Hi
There are no attachments.
Sorry forgot to upload
Hi, see if this is what you want.
You will need to open both the Help and Inventory file.
Click on the Import Data button and select which sheet you want to import from the combobox.
That works great. Thanks so much for the help. big Time Saver at Work.
You are welcome 
