Transfer Tabs from input file to Output file

[kauser]

Hello, 

My Input file have multiple tabs and few tabs i need to transfer into my output file (with same format- table, highlighted rows). i use this formula below with formula tool but then it takes all other tabs into my output file

REGEX_Replace([FileName], "\|\|\|.+", "|||New Sheet")

For example- i want to transfer these two tabs name -John, Bob into output file out of eight tabs from input file but when i use this formula above it takes all eight tabs  into output file. 

can you show me how can we transfer these two tabs John & Bob out of eight tabs from input file to output file. Also i want to keep on same format. 

[cjaneczko]

Use a filter tool and filter out the tabs you don't want to be in your output file. 

[kauser]

Thanks ..... But how can we filter out tabs from an input file. please advice. 

[cjaneczko]

Bring the tab names in as a Field on the input tool. 

[kauser]

This is my input tab that i want to move into output file but every time i tried its come out in a different formar. such as when i transfer into to output file data come without $sign and also lost % . i want to mirror the data from input tab to output tab 

Item	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE
1	$                4,578.00	$               458.00	$              1,245.00	$                    93,124.00	$                4,786.00	$                4,589.00
2	$              22,890.00	$           2,290.00	$              6,225.00	$                  465,620.00	$              23,930.00	$              22,945.00
3	$              45,780.00	$           4,580.00	$           12,450.00	$                  931,240.00	$              47,860.00	$              45,890.00
4	41,202.00	4,122.00	11,205.00	838,116.00	43,074.00	41,301.00
5	114,450.00	11,450.00	31,125.00	2,328,100.00	119,650.00	114,725.00
6	91,560.00	9,160.00	24,900.00	1,862,480.00	95,720.00	91,780.00
7	419,161,680.00	4,195,280.00	31,000,500.00	173,441,587,520.00	458,115,920.00	421,178,420.00
8	4.00%	48.00%	81.00%	65.00%	20.00%	58.00%
9	419,047,230.00	4,183,830.00	30,969,375.00	173,439,259,420.00	457,996,270.00	421,063,695.00
10	114,450.00	11,450.00	31,125.00	2,328,100.00	119,650.00	114,725.00