Paste into new workbook and save as depending on folders contents

I need a macro that copies all data on sheet1 in my open workbook and then opens a new workbook and pastes special as text into the new workbook. I then need it to save the new workbook as TigerX Csv file where x is a number. I need the number x to be determined by looking in a folder where there are already Tiger1 Tiger2 etc etc files and if the last number used was 2 then it would be saved as csv Tiger3. Any ideas??

Any way of writing a macro to check last used number in a specific folder?