I want to have custom footer and header where i can increment the page # so if the page # is 1 and i want it to be 6 (other pages from pdf are pages 1-5 how can i do this? i tried

ActiveSheet.PageSetup.CenterFooter = (IIf(blnBoard, "&B&14&P" & "+" & mynum, ""))

but i get 15 when i look at the page setup dialog i see:
&[Page]+5

how can i do this??

On Page Setup, on the Page tab at the bottom is a box labelled "First Page Number" which defaults to Auto. If you always want it to start at 6 for this workbook (possibly worksheet, not sure), just change here and save the workbook.

If you want to be able to change the starting number in code then you need:
ActiveSheet.PageSetup.FirstPageNumber = [whatever you want it to equal]