Convert Many Invoice Formats to a Standard Format

[joeny0706]

I have this Table in the Project Workbook. Please Fill in the blank Client & SubFolder info for Indepentants(sic)

Client	Store Data SubFolder	File Name With Pattern	Pattern	File Type
Flexibake	Flexibake	HEIDELBERG-INVCR&Pattern	"mmddyyyy"	csv
Albany	Albany	Heidelberg KKB &Pattern	From To "mmddyy-mmddyy"	csv
midstate	midstate	Pattern&_Recap	"mm.dd.yy"	xls
ahold	ahold	0056919000647_0004353672		csv
kkb	kkb	Heidelberg KKB &Pattern	From To "mmddyy-mmddyy"	csv
vbc	vbc	VBC HB&Pattern	From To "mmddyy-mmddyy"	xlsx
		Indepentents		csv

Independents are a type of customer. There is no raw data that comes from independents. All the raw data has customers that are independents. I am not sure if I am understanding you questions correctly.