Hello all - I need help with a macro. I have a workbook with multiple worksheets. I need to create a macro to copy data from certain worksheets Ex: Range(A4:F20) only from worksheets with a name that starts with the number 5. Example the names can be 5432, 5542, 5998 etc. I'm having trouble getting my loop to work.
Thanks.
Thanks.